RowSource property of Combo Boxes - selcting with VB code or SQL expression ??

poulsotw

Registered User.
Local time
Today, 21:38
Joined
May 6, 2003
Messages
17
Hello

I haven't done a great deal of work with MS Access or other application other than the very very simple. I am currently trying to get my head around manipulating the rowsource for a combobox on a simple form.

The table that the form is based on is very straightforward with a bunch of text boxes and 2 drop down boxes that I have set as combo boxes. The idea is that the choice in combo box 1 influences which table the RowSource property of combo box 2 is referred to.

I have spent a few hours looking through the MS Access help file and it gets quite close to explaining but doesn't hit the nail on the head. The text books I have don't go into detail either.

It seems there are numerous methods of dealing with this including VB Code and SQL expressions. The crude attempts I have made so far have yielded no results - the best yet being that the table or query referred to in my VB expression is misspelled or doesn't exist. Even with this I am not convinced I have put the expression in the right place.

I know this must be an incredibly common requirement, does anyone have a foolproof method they can recommend or somewhere I can look up the answer ?

cheers,
TP.
 
There have been numerous posts regarding Cascading Comboboxes on this forum - try doing a search.
 

Users who are viewing this thread

Back
Top Bottom