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

Add a record providing part of the information

P: 3
I am trying to add a record via a form where the user doesn't enter all the data. This sounds jumbled...Basically, I want to add a record to the XYZ table containing fields ID, Name and Description associated, by ID, with an existing record in the MAIN table. So the user will input Name and Description. The program will set the ID and then enter the row into the XYZ table. This is simple, right ? Any help would be appreciated. Especially help of the KISS mentality. Can I use
doCmd.GoToRecord, acNewRec ?

Aug 8 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,392
So... you have a main table but you want to enter records into a related secondary table? Why not use a subform?
Aug 8 '07 #2

Post your reply

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