Database Control source question.

[Guest]

I'm relatively new to Access and suddenly had to take over a former
employee's database. I was successful in adding a combo box to one of the
pages, however I do not know how to create a control source in the properties
menu. Also, I have entered the Row Source Type as - Value List, but can't
get any of the values I entered into the Row Source to show on the database
page. This is a multi page multi report running database and I have been
given it with no training. Please advise.

 

[Roger Carlson]

Okay. Lets start with some terms and definitions just so we're on the same
page.

The ControlSource of a combobox is a field (if it's a bound control). That
means the field has to exist in the dataset that the form is based on. You
don't *create* a control source, you *select* it from the list. In the
ControlSource property, there should be a list of available fields in a
drop-down. If it's not there, you need to add it to the table or query that
makes up the Record Source of the form.

The RowSource property is where you put the values that will appear in the
drop-down of the combobox. These values will only show up when you click
the down arrow. Once you've selected a value from the list, it will be
stored in the Control Source, with goes right back to the base table or
query.

Does that help?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

O.K. I figured out that I needed to create a table and have done so. Now I
have a control source for my combo box, but I still cant get any values to
show in the box....could really use some advice.

 

[Guest]

Thanks for the info. Yes that does help quite a bit, but there's still a
problem. I have created a table for it now in the Record Source, selected
the proper field in the Control Source set all of the fields exactly as the
other Combo boxes and still can't get any values I type into the Row Source
to show in the drop down box.

 

[Guest]

O.K. I have it all figured out. I deleted the box and started from scratch,
it iis working perfectly now! Thanks so much for all of your help!!