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.
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.