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

Access Subform cannot add record after upsize

P: 3
Need bit of a help with Access to SQL subform queries
i have upsized a Access DB. It also has a Access frontend. The upsized went ok. I relinked the Access linked table to SQL. When I try to add a record in a form that has a subform, I cannot add records in subform. The issue is when i double click on a field on the main form to add a record, a select statement runs to check the other tables to see if there is any record exist for that new number. Obviuosly its a new record and no linked data exist yet. I cannot work out how I can make the subform then go into insert mode when it return blank for the subform.
Sep 12 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
You need to look at your relationships in SQL. Have you set up your foreign keys, constants, triggers, etc.

The issue here is with the SQL. What language are you using and I will move this to the appropriate forum?
Sep 13 '07 #2

Post your reply

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