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

Autonumber Lookup

P: 1
On a form based on table A, when a new record is started, I want to go to table B, and get the next value generated by an AutoNumber field on table B. This value would be then entered into the form and into table A. If someone has tried this before the question is this, is it easier to write code or just create a subform and update both A & B at the same time?

Any thoughts appreciated
Dec 26 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
Strange way to synchronize tables.
I would use a main form on table B and add a subform for table A, linked by the autonumber field. Now adding a row in the subform for table A will automatically set the proper ID in table A.

Dec 30 '07 #2

Post your reply

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