Refresh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Noramally, you use an unbound combo box for this sort of task. The combo box
wizard should walk you through creating one.
 
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.
 
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.
 
Back
Top