Second form with primary key from main form

E

eb1mom

I have about 20 forms in an old database used to record equipment delay time.
Users open a form and a delay start time is automatically entered. When
equipment is back online, a button is clicked to enter delay time. I would
like to create a button on delay form that would open a repair form. Primary
key on delay form would be foreign key on repair form. How do I correctly
code repair form to use primary key from whichever equipment delay form is
open? thanks
 
N

Nikos Yannacopoulos

The code behind the command button would include the following:

strFormName = "frmEquipmentRepair"
DoCmd.OpenForm strFormName
Forms(strFormName).EquipmentID = Me.EquipmentID
DoCmd.Close Me.Name

which opens the repair form, and sets the ID value on the newly opened
form to the one in the current form (Me. translates to "this form" in
plain english). The last line closes the current form.
Hope my naming assumptions are self-evident, so you can substitute the
actual form and control names.

HTH,
Nikos
 
E

eb1mom

Nikos Yannacopoulos said:
The code behind the command button would include the following:

strFormName = "frmEquipmentRepair"
DoCmd.OpenForm strFormName
Forms(strFormName).EquipmentID = Me.EquipmentID
DoCmd.Close Me.Name

which opens the repair form, and sets the ID value on the newly opened
form to the one in the current form (Me. translates to "this form" in
plain english). The last line closes the current form.
Hope my naming assumptions are self-evident, so you can substitute the
actual form and control names.

HTH,
Nikos

Nikos, your code was huge help. Thanks for your time. Eb1mom
Click to expand...
 
Top