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

How do I Automatically insert 5 records on a form?

P: 6

I have a form called frmTraining Plan and when I set up a new employee I want to populate frmTraining Plan with 5 training records. These records are always the same, so I would like to automate with VBA somehow.

The form has CourseID Field, EmployeeID Feild, Requirement Feild and Time Frame Feild.

Your Assistance is much appreciated

Oct 23 '08 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,492
Check out Basic DAO recordset loop using two recordsets and let us know if this helps.

We can still help with specifics if you need when you have digested the main point.

Welcome to Bytes!
Oct 24 '08 #2

P: 6
Hi Thankyou for welcoming me appreciate it.

I'm not sure if I understand the code correctly but is it for finding matching records and then updating the form?

If it is what I need is something that when a button is clicked the same records every time, populate the feilds of another form.

Oct 27 '08 #3

Expert Mod 15k+
P: 31,492

The link was a starter for updating data using DAO recordset code. It wasn't because it necessarily gives a similar result.

See what you can do from that basic information and let us know if/where you get stuck.
Oct 28 '08 #4

Post your reply

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