Opening a form based on individual record

[swee]

All my records are displayed on a form. Upon clicking on their respective 'View' button, I would like to open that particular record. How can I do that? I have attached a screenshot for better clarity. Thanks in advance for the help!

Regards,
Swee

 

[maxmangion]

on the OnClick event of your view button put the following:

DoCmd.OpenForm "FormName" , , , "[Fieldname]=" & Me.Fieldname

 

[Rich]

You only need one button in the footer and the Button Wizard will create the code for you

 

[swee]

Thanks guys. Got it working using the OpenForm method.

 

[maxmangion]

Good to hear that you've sorted out your problem