SubForm issue

[sprasad123]

Hi there,
Wondering someone can thow some light to my problem Access Problem. I have upsized a Access DB to SQL and also got a Access Linked table as a front end. Relinked the linked DB to the SQL DB.
When I try to add a record to the DB using the form, the lines on the subform does not come up to enter the data. The main form lets me enter the data. The subform is for differnt table to main form.


thanks.

[Jim Doherty]

Hi there,
Wondering someone can thow some light to my problem Access Problem. I have upsized a Access DB to SQL and also got a Access Linked table as a front end. Relinked the linked DB to the SQL DB.
When I try to add a record to the DB using the form, the lines on the subform does not come up to enter the data. The main form lets me enter the data. The subform is for differnt table to main form.


thanks.

Make sure the Primary key on any table upsized to SQL server is set. You will not be able to input data if this IS the case

Jim

[sprasad123]

Make sure the Primary key on any table upsized to SQL server is set. You will not be able to input data if this IS the case

Jim

thanks Jim for that. I did put the primary index on the tables before I upsized. It lets me update the existing records but to Add a record, I double click on a field in the main form and this should let me add in the subform as well. The following is the code it runs on double click on a field on the main form. this was running ok when the database was not upsized .

Private Sub Job_Number_DblClick(Cancel As Integer)
DoCmd.OpenQuery "New"
Me.Requery

End Sub

Anymore suggestions would be appreciated.

[MMcCarthy]

thanks Jim for that. I did put the primary index on the tables before I upsized. It lets me update the existing records but to Add a record, I double click on a field in the main form and this should let me add in the subform as well. The following is the code it runs on double click on a field on the main form. this was running ok when the database was not upsized .

Private Sub Job_Number_DblClick(Cancel As Integer)
DoCmd.OpenQuery "New"
Me.Requery

End Sub

Anymore suggestions would be appreciated.

Post the SQL of the query "New"