Can I have a form that inserts multiple data

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
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.
Click to expand...

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?
 
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.
Click to expand...

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