A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

go to a record



 
 
Thread Tools Display Modes
  #1  
Old July 2nd, 2004, 10:16 PM
joeandtel
external usenet poster
 
Posts: n/a
Default go to a record

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?
  #2  
Old July 5th, 2004, 01:39 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default go to a record

Is the combo box bound to an underlying data field?

--
More info, please ...

Jeff Boyce
Access MVP
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Button to print current record only Fatz Using Forms 6 June 17th, 2004 01:58 PM
Problems with record locking Ronny Salomonsen General Discussion 0 June 14th, 2004 09:37 AM
Form Doesn't Go To New Record Steve New Users 15 May 16th, 2004 04:33 PM
Form Does Not Go To New Record Steve New Users 1 May 12th, 2004 03:15 AM
Avoid Creating A Duplicate Record Mark New Users 4 May 11th, 2004 01:52 AM


All times are GMT +1. The time now is 11:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.