Adding new record to form using the field data from current form

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

Guest

I have a main form and subform, one-to-many relationship. When the user
clicks the checkbox for one of the records in the subform, I want to open
another form and populate that form with the current record's field data.

I am in a time crunch here otherwise I would research this on my own. Can
someone help me out?

Anything would be greatly appreciated!
 
Hi Diane,

More information needed.

Is the "other form" bound to a table or query? If so, does that table
already contain a record related to the current record in the subform;
or do you want to create a new record in the table; or do some records
in the subform have an existing related record in the "other form's"
table and others not?

How are the tables underlying the subform and the "other form" related?

What do you want to happen if the user clicks the checkbox on one record
in the subform and then clicks the checkbox on another record without
doing anythning to the "other form"?

What do you want to happen when the user clicks again and clears the
checkbox?
 
John,

Thank you so much for responding to my post. Due to time contraints, I had
to take a different approach. But I appreciate your assistance.
 
Back
Top