Adding Records to a Table using an Array and Control Values

[Guest]

I'm a real novice at Access Forms and very rarely use VB

I'm building an application to store attendance lists for meetings. I have a form where I want to enter the details of the meeting (date, location, etc.) once and then list the attendees. When the 'Record' control button is pushed, I want to create a new record containing the meeting details and the attendee name for each attendee name entered. For example, if I entered five names, then five records would be created

I know how to collect the meeting details using various controls (i.e., combo, date, and text boses). I know how to build records the form data using VB when a button is clicked. What I need help with is building the array of attendee names in either a control that stores an array or builds a temporary table that can be used by the VB procedure to do the record build.

 

[Lynn Trapp]

That's what a form/subform is for. Create a table for Meetings and one for
Attendees. They will be related 1 to Many, joined on the primary key for
Meetings and foreign key in Attendees. You can use a wizard to create the
form/subform for you.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I'm a real novice at Access Forms and very rarely use VB.

I'm building an application to store attendance lists for meetings. I

have a form where I want to enter the details of the meeting (date,
location, etc.) once and then list the attendees. When the 'Record' control
button is pushed, I want to create a new record containing the meeting
details and the attendee name for each attendee name entered. For example,
if I entered five names, then five records would be created.

I know how to collect the meeting details using various controls (i.e.,

combo, date, and text boses). I know how to build records the form data
using VB when a button is clicked. What I need help with is building the
array of attendee names in either a control that stores an array or builds a
temporary table that can be used by the VB procedure to do the record build.