Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find Record Help

Status
Not open for further replies.

LStylz

IS-IT--Management
Jun 8, 2004
41
US
Is there away to have a button on your form, where you can type in some or all of a persons name and go straight to that record? I thought the find record button was it but I get an error when I add it
 
I get an error when I add it
Any chance you could post the whole error message ?
You may also consider following the combo wizard to do what you want without a button.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
LStylz

Have you tried using the combo box or list box wizard?

Add an unbound combo box...
- Click on the combo box button from the toolbar, and place the combo box on the form.
- Select "Find a record on my form based on the value I select..."
- Select the field in question that you want to pick from
- Sample data is displayed. The "Hide key column" is usually selected. (Access will actually add the primary key as well as the field you selected)
- Provide a suitable descriptive lable

This will work provided you use a suitable link field.

A little more detail...
As mentioned, Access will add the primary field to the "search process". The primary field is key to the search process, and is the "bound column". For example, for your contact database, Access will use something like this if you selected the Last and First names of the contacts...[tt]
SELECT ContactID, LastName, FirstName From...[/tt]


Richard
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top