Adding Records to a Table using an Array and Control Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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


Kevin Rodriguez said:
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
Click to expand...
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.,
Click to expand...
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.
 
Back
Top