Creating data in one from from another

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

Guest

I have a DB that has two seperate data forms i want to be able to open one
form from the other and insert some detaisl from the first form into it.

eg. Form one has asset field there is a button to open second form i want it
to link with the form record and input the asset number.
 
One way of doing this is by 'pushing' the value like this:

DoCmd.OpenForm "Firstformname", acNormal
Forms!Secondformname.Fieldname = Forms!firstformname.Form.fieldname

Replace the firstformname with your mainform and the fieldname you want to
push (e.g. assetnumber)
Replace the secondformname with the form which you are opening and replace
the fieldname with the fieldname in your secondform in which you want to
place the pushed value (e.g. assetnumber)

hth
 
Back
Top