linking forms

[shrive22]

I have an initial form that only shows the user a few fields then lets them select the record they want to update, then it opens up my second form with all of the fields. How can I get the second form to open up directly to the record that was selected from the first form??

thanks for the help

 

[Russell Hauf]

Look up the ApplyFilter method in Help.

So you would open your 2nd form from the first - something like:

Docmd.OpenForm "frmMyForm"
Me.Visible = False

Then, in the 2nd form, in the Open event, put something like

DoCmd.ApplyFilter , "[fldOne] = '" & Forms!frmOne!txtOne & "' AND [fldTwo] = " _
    & Forms!frmOne!txtTwo & " AND [fldThree] = '" & Forms!frmOne!txtThree & "'"

Where fldOne and fldThree are text fields and fldTwo is a numeric field. You just hide your original form, then build a WHERE clause (used in ApplyFilter) to filter your main form.

HTH,

Russell