openform

[ibrahim_basry]

i have 2 forms i want to go from [form 1] to [form 2] in the same record from form 1 i tried to use [student no] = Forms![form 1]![student no]
it asked to entre the value of the student no
and i tried the code also
plz help

 

[David R]

What happened when you tried the code? Error, nothing, bad result? We need more information...

Probably you want something like

Forms![Form2].Filter = "[student no] = " & Forms![form 1]![student no]
Forms![Form2].FilterOn = True

or

DoCmd.OpenForm "Form2",,,"[student no] = " & Forms![form 1]![student no]

 

[pr2-eugin]

Hello ibrahim_basry, Welcome to AWF

I am sorry, but I cannot understand what you are trying to accomplish here. Is there a button where you use to open the Form? Have you checked. Open a second form to the record selected on the first form