Open form based on a query

[sharpnote]

I have a form with search field which when filled up returns a particular record based on a query. Now, I wanted to open that particular record on a form where it was encoded. please help. thanks

 

[John Big Booty]

Check out the Where condition of the DoCmd.OpenForm, it will look something like;

DoCmd.OpenForm "YourFormName", , ,"YourLinkingID= " & Me.YourLinkFieldOnForm

This code assumes that your link is numeric, if it is text use;

DoCmd.OpenForm "YourFormName", , ,"YourLinkingID= [B][COLOR="Red"]'[/COLOR][/B]" & Me.YourLinkFieldOnForm [B][COLOR="Red"]& "'"[/COLOR][/B]

 

[sharpnote]

Thank you John Big Booty. Though I haven't tried the code due to tremendous work load lately, I'll try this and get back to you as soon as I can. Thanks again.

 

[sharpnote]

It is working!!! Thanks a lot John Big Booty. Hope I can count on you next time around. thanks

 

[John Big Booty]

Glad I could help