PDA

View Full Version : Is it possible to add a list of items to a blank combo box using visual basic code?



wedd
12-19-2011, 08:05 AM
I have a blank combo box on my customer form...there is a combo box which is empty in other words simply there isn't any list items in the combo box. Is it possible to add a new list or creating a list of items to a blank drop down list or combo box on a form? The source of where the list items are is in a table...and I only thought of creating a drop down list on my form...so I was wondering if this was doable rather than creating a new form. Can this be done? If so, would you know of any sample code or websites or resources on how I could do this? I am a bit of a novice/intermediate user of visual basic in access.


Thanks for all your contributions:friends:

orange
12-19-2011, 09:36 AM
Open your form in design view.
Click on the combo involved and select properties.

Add the table and the fields you want as shown in the attached jpg.

Should get you started.