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

Open another table in VBA from a form and add data

P: 21
In a database I want to add a record to several tables that are not currently open on the form. I used to toy with recordsets but have since forgotten (old age). How do I add a record and then insert some text? The filed I want to insert is an ID (I call it FACID for Facility ID that is my common link to all tables because the tool reports on facilities). Any help would be appreciated.
Oct 17 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,366
Instead of going through the trouble of opening a recordset and then adding data, why not just use DoCmd.RunSQL?
Oct 17 '07 #2

Post your reply

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