By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,659 Members | 1,750 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,659 IT Pros & Developers. It's quick & easy.

combo box not selecting names i select

P: 5
Hi
i have a combo box with fields surname,firstname,and ID #. however i can not seem to select any names that are duplicated in surname. Smith for instance, i have 4 different people with that name but i can not select any of them? any help would be great as i have lost days on this problem.
Jan 24 '08 #1
Share this Question
Share on Google+
3 Replies


Delerna
Expert 100+
P: 1,134
do you have the id as the link between the combo box and the form it is on
Jan 24 '08 #2

missinglinq
Expert 2.5K+
P: 3,532
Some questions:

Was the combobox made with the wizard?

Is the order in the combobox Surname - firstname - ID?

What is the purpose of this combobox?

Welcome to TheScripts?

Linq ;0)>
Jan 24 '08 #3

P: 5
Some questions:

Was the combobox made with the wizard?

Is the order in the combobox Surname - firstname - ID?

What is the purpose of this combobox?

Welcome to TheScripts?

Linq ;0)>

hi guys thanks for replying i am desparete! i have been stuck on this for days.

my forms recordsource is;

SELECT TblTempOnly_PoolContractDrivers.id, TblTempOnly_PoolContractDrivers.rego, TblTempOnly_PoolContractDrivers.DriverSurname, TblTempOnly_PoolContractDrivers.DriverFirstname, TblTempOnly_PoolContractDrivers.StaffNo, TblTempOnly_PoolContractDrivers.PrincipleCarRego
FROM TblTempOnly_PoolContractDrivers;


my cbo box is

SELECT TblTempOnly_PoolContractDrivers.DriverSurname, TblTempOnly_PoolContractDrivers.DriverFirstname, TblTempOnly_PoolContractDrivers.StaffNo, TblTempOnly_PoolContractDrivers.id
FROM TblTempOnly_PoolContractDrivers
ORDER BY TblTempOnly_PoolContractDrivers.DriverSurname;


iwhat i want is to refresh the data when they click on it. so if there is a name that is not in they go to a specific form depending on category and add it. i then want it to run those 2 queries to combine the 2 tables into one so the up to date data shows in the combo box (ie new name entered). for some reason only a few dup names are not letting me select. am i making sense?
Jan 25 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.