Can I have a form that inserts multiple data

[Chris]

I am rather new to Access and am trying to create a
subfom. This subform is based on a table and I would like
to be able to select multiple lines of data and when
complete update a table upon clicking a button. Is this
possible.

Regards,

Chris

 

[John Vinson]

I am rather new to Access and am trying to create a
subfom. This subform is based on a table and I would like
to be able to select multiple lines of data and when
complete update a table upon clicking a button. Is this
possible.

Not really, and it's not something you'ld ordinarily want to do in any
case. Are you talking about storing the same data redundantly in two
tables? Why? What are you actually trying to accomplish in the real
world?

 

[John Vinson]

No I want to have a subform that shows people that are
available for a test study.

The main form would allow me to enter data as to what kind
of a study I am doing. The subform would show me who is
availabe based on a query. I would then like to select
people that are available and have them entered into that
study on the main form.

It sounds like you have a many to many relationship between Studies
and People. You would need (and perhaps you have, you don't describe
your tables!) an Enrollment table linked one to many to both the
Studies table and the People table. The subform would be based on
Enrollment; you would use the StudyID as the master/child link field
and probably have a Combo Box, based on the query of available people,
bound to the PersonID to select the person.