Refresh

[Michelle]

I have a form that runs from a query that joins 3 tables together.
What I would like is for when a user enters the employee # that it auto
fills the Name and related employee information.
Example:
Employee #: (you enter)
Name: (auto fill)
DOB: (auto fill)
Start Date: (auto fill)

I tried refresh and it does not seem to work.

 

[Klatuu]

Noramally, you use an unbound combo box for this sort of task. The combo box
wizard should walk you through creating one.

 

[Michelle]

I don't think that is what I am looking for:
Here is what I have 1 table with Employee information, 1 table with comments
and notes about the employee and 1 table with a list of job titles.
The query combines all 3 tables on the from you select the job title with a
drop down box then you should be able to enter the employee # in the next box
after you enter the employee # I want it to pull the Name, address, DOB,
start date, pay then I want to be able to add comments etc to it.

 

[Klatuu]

Okay, but my response is still the same.

You can't use a bound control as a search control. Regardless of whether
you use a text box or a combo or any other data control to search, if it is a
bound control you will cause the value in the current record to change to
what you are looking for. If it is a primary key, you will get an error.