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

criteria on combo box

P: n/a
hi all,

I have a form in which there is combobox which has empnames listed
and a textbox which has empIDs. textbox value is loaded from the
table, i have written a query which sets the criteria for combo box to
select the name that its ID is written in textbox. It does the filter
and the name is there in the combo but the problem is I have to click
on dropdown and select the name.

Could you please guide to automate the name selection in combo?

I thank you in advance,

Aug 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Farhaad Faaique" <fa******@gmail.comwrote in message
news:a4**********************************@r66g2000 hsg.googlegroups.com...
hi all,

I have a form in which there is combobox which has empnames listed
and a textbox which has empIDs. textbox value is loaded from the
table, i have written a query which sets the criteria for combo box to
select the name that its ID is written in textbox. It does the filter
and the name is there in the combo but the problem is I have to click
on dropdown and select the name.

Could you please guide to automate the name selection in combo?

I thank you in advance,
Try using the After_Update event of the empID text box to set the combo box
value.
Something like this:

Me.empname = dlookup("empname","tblEmployees","empname=" & empID)

Fred Zuckerman
Aug 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.