go to a record

G

Guest

I have a table with names of employees in it. This table has a primary key for each employee. I have another table that has the employee id as the foreign key. I want to display a combo box where I can select the employee Id and go to the first record of that search, but the drop down list always shows the same id number over and over again. How can I display the list of employees with unique names and go to the first record selected?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'Go to Record' button - simple task but can't get it to work 1
How to make it so users see only certain records in a database 3
select date from list 1
Choose a record without making a subform 6
Using Combo Box Selection to Query a Table 3
Name saving as ID 5
GoTo a record from a combo in the form 4
Excel VBA - counting cells by colors and names to it in two different rows. 0

Top