Creating data in one from from another

M

mjcppe

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.
 
M

Maurice

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
 
Top