opening form to a particular record

D

David

With help I've worked out one of my major problems, now onto something minor.
For each entry into my table I give it a private catalog number (which is not
the table key). I would like to create a form that would ask for this number
then use it to display te corresponding information in the table (or from a
query) in new form that opens.
Thanks
 
A

Al Campagna

David,
I think what you want is something I call a "Combo Quick Find". Using a
combobox on your form, that lists every PrivateCatNo in your recordset...
the user selects a PrivateCatNo... and you are taken to that specific record
within the recordset.
On my website (below) I have a sample 97 and 2003 file that shows how to
do that.
--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
 
S

Steve

David,

If this is a followup question to my first recommendation, in the second
form with the textboxes, if you are displaying the catalog number put the
following code in the click event of that field. If you are not displaying
the catalog number, add it to your form and set its visible property to
False then put the following code in the clck event of one of the other
fields.
DoCmd.OpenForm "NameOfFirstForm",,"[CatalogNumber] = "'" &
Forms!NameOfSecondForm!CatalogNumber & "'"

The above assumes that CatalogNumber is text. If it is numeric, use:
DoCmd.OpenForm "NameOfFirstForm",,"[CatalogNumber] =
Forms!NameOfSecondForm!CatalogNumber

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
Top