Adding and copying data from form to form

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello I have a problem with Access 2000 I was wondering if
there was a way to get a refrence number to be carried on
through a few forms. It needs to be inputted once on the
first form and then on all teh other forms which follow it
needs to take the refrence number and place it into the
same field in another form. Then it needs to add that info
to a table.

How can I achieve this?

Many THanks

James
 
The best way would be to use the OpenArgs property.
When you call the other forms from the first form, use the
reference number field as the last argument as follows:
DoCmd.OpenForm(Formname, , , , , ,Me![Reference#Field])
This carries over the current record's reference field
value from the first form.
Then, in the OnLoad events of each form, you place the
value of the reference number in its field by refering to
the forms openargs property:
Me![Reference#Field] = Me.OpenArgs
 
Back
Top