?
Solved

Combo Box not Working

Posted on 2012-03-29
3
Medium Priority
?
436 Views
Last Modified: 2012-03-30
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.
0
Comment
Question by:gigifarrow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 12

Expert Comment

by:danishani
ID: 37785485
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
 
LVL 12

Accepted Solution

by:
danishani earned 1000 total points
ID: 37785708
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
What we learned in Webroot's webinar on multi-vector protection.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question