By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 838 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.

Re: criteria on combo box

P: n/a
"Fred Zuckerman" <Zu********@sbcglobal.netwrote in message news:...
"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
oops, typo, should be:
Me.empname = dlookup("empname","tblEmployees","empID=" & empID)
Aug 29 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.