Combo Box not Working

I was kind enough to get this code from an expert on this website. However, when I try to duplicate what he did it doesn't come out right.

Okay what I am trying to do is add the combo box to display serial numbers. Now the original field from the table that is not a combo box. He took a unbound combo box and put code in it to search for serial numbers from the Serial Number field in the  table that holds all the serial numbers in it.

Here is the code that is done After Update:="[Serial Number] = " & "'" & [Screen].[ActiveControl] & "'"

When I display my  combo box that is unbound nothing shows up in the drop down of my form.  Im not getting any errors either.
gigifarrowAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

danishaniCommented:
So what is the rowsource of your Unbound Combobox?

What has the AfterUpdate event to do with the Combobox?

What thread are you referring too? You might post this as well.
0
gigifarrowAuthor Commented:
0
danishaniCommented:
Yes thanks for the reference.

So what do you have right now in place for your Combobox?
When a Combobox is blank, there is either something not mathing in the rowsource (query) or there is no recordsource at all.

Below a link on how to create a Combobox:
http://office.microsoft.com/en-us/access-help/create-a-list-of-choices-by-using-a-list-box-or-combo-box-HA010113052.aspx

Hope this helps,
Daniel
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.