Ms Access Search problem 1

[4808]

i'm trying to create a search dialogue with an option box,a text box that shows option selected, an ok and cancel button. could someone help with a code for the OK button please, such that when a row is select from the text box it is displayed on a designated form.
thanks.

 

[Frink]

Hallo,

The code you probably want is something like:

docmd.openform "frmFormName",,,"lngPrimaryKey=" & me!txtPrimaryKey

This assumes that your text box is called txtPrimaryKey and contains a unique identifying number for the record to be displayed. frmFormName should have the table containing the records to be displayed as its recordsource.

- Frink

PS If you need more help, we'll need to know more info about your tables/fields and forms/controls