Find Record By Entering Data

[statsman]

I have a form which my client likes but he doesn't like to use a search button.

The two indexed fields are EMPLNO and LASTNAME.

By entering the employee number into the form and/or by entering the lastname onto the form you would get the record for that employee onto the form.

Its probably covered in the archive but I don't know what to look for.

Any suggestions?

 

[Kraj]

Add a combo box to your form. When the wizard pops up, change the first option from the default to "Find a record on my form based on the value I selected in my combo box". Then follow the rest of the wizard instructions.

 

[statsman]

KRAJ:
I probably didn't explain myself very well. The form has 12 fields on it. The two indexed fields are employee number and last name.
The previous database (done in FileMaker I believe) would present you with a blank form. By entering either the employee number in the emplyee number field or the the employee surname in the last name field, the form would automatically fill with the rest of the information. No combos, no buttons.
The client wants the same thing in his Access database.

 

[Kraj]

Is this form purely for displaying employee information? If so, what I told you to do is exactly what you should do. Instead of adding two additional combo boxes, use the combos for the employee number and last name fields and get rid of the text-box versions. If not, you need to explain what you're trying to do.

 

[gilescis]

Kraj,
Thats makes sense for what I am looking for except my form is the same form as what the user enters data in, What I need is for the user to open this form, the control goes to the first field, then from here the user can click in a field that they want to search on. Example

I have a field called PO
I want the user to click in the po field and enter a po# then click a search button and retrieve the data into that same form, then I want them to be able to update that record or be able to change any field in that record then save back to the table without it added it as another record.

Thanks