Data carry over

G

Guest

I currently have one form which gets its id number from a previous form. However when i add a new record the id number is not carried over. Is there a way which i can get the id number to carry over for each new record
thank
 
J

John Vinson

I currently have one form which gets its id number from a previous form. However when i add a new record the id number is not carried over. Is there a way which i can get the id number to carry over for each new record?
thanks
Click to expand...

By far the simplest way is to make the second form a Subform of the
first, using the ID as the master/child link field.

If you really need separate forms, you can pass the ID in the OpenArgs
argument of the OpenForm method, and use the second form's Open event
to set the Default property of the ID field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Carry over values from previous record 6
carry over field 4
Access Use a form button if most data is to be duplicated on another new record. 0
Carrying over a new total figure from previous record to new recor 1
automatically fill in data in new form 3
Carrying over data between fields 8
Filling in fields to a partially complete record in a table using a form 0
Form not carrying names to table behind the subform. 7

Top