Forms (2003)

Topic

New Reply

Ok…here is my problem. I have 3 forms. 1 form allows the user to enter information about a renter. Form 2 – allows the user to enter information about the complex – each room. To attach the renter to the room, I have created a 3rd form. What I would like to do, is on the renter form, enter all demo information and then click on a button to open the 3rd form and for it to automatically display the renter information and then let me select the appropriate complex and room. I can’t seem to transfer the renter to the 3rd form…I am having to pick from a drop down.

Any help would be appreciated!
Deborah

Reply | Quote

Replies

I assume that you have a field that uniquely identifies the renter, let’s call it RenterID for illustration purposes.
You can pass the value of RenterID from Form1 to Form3 in the OpenArgs argument of DoCmd.OpenForm:

DoCmd.OpenForm FormName:="Form3", DataMode:=acFormAdd, OpenArgs:=Me.RenterID

You can inspect OpenArgs in the On Load event of Form3:

Private Sub Form_Load()
If Not IsNull(Me.OpenArgs) Then
' Do something with the value of RenterID here, for example
Me.RenterID = Me.OpenArgs
End If
End Sub

Reply | Quote

PERFECT!!!

Thank you, Hans…as usual…you are great!

Reply | Quote