By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,103 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

SubForm issue

P: 3
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.
Sep 10 '07 #1
Share this Question
Share on Google+
3 Replies


Jim Doherty
Expert 100+
P: 897
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
Sep 10 '07 #2

P: 3
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.
Sep 11 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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"
Sep 13 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.