Advertisement

11.21.2008 at 01:14AM PST, ID: 23924440 | Points: 500
[x]
Attachment Details

How can I create several records with the same info from one form?

Asked by nikez2k4 in Microsoft Access Database, Access Forms, VB Script

Tags: ,

I have a table setup (General Bookings) that stores an ID for a faciliy that is being booked (FacilityID). I also have a form that saves the information to the General Bookings table.

At the moment I have a combo box that allows the user to select one facility to be booked, however I would really like to provide the user with checkboxes that allow them to book multiple facilities from 1 form.

Is it possible to save multiple records in the General Bookings table when the user clicks the "Save and Close" button? One for each facility check box that is checked (i.e. one record for each facility required).

Would this require some VB to be used? If, so could you explain how it works as VB isn't my 1st language :-)

Thanks alot,
JamesStart Free Trial
[+][-]11.21.2008 at 01:47AM PST, ID: 23011489

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.23.2008 at 02:19AM PST, ID: 23024325

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.24.2008 at 02:13AM PST, ID: 23027231

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.10.2008 at 12:32AM PST, ID: 23137163

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628