var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Combobox's and coding question
I am building a database for tracking medication errors in our facility. Here is my scenario:
I have a combobox with 5 options when it drops down and I have a combobox below it that will contain options when opened that depends on the one above it.
Combobox1 has choices a, b, c, d, e
If a is chosen combobox2 will contain the items pertinent to a.
If b is chosen combobox2 will contain the items pertinent to b.
and so on and so on.
I would appreciate if someone would point me in the rih=ght direction. I know I am close, but I can't find any help in the access 2000 wizard or in my Access 2000 book.
You need to set the combobox2 row source property to a Query that will get vaules form your table where combobox1 value is true.
ie if combobox1 = a
then select * from table where table.field = combobox1(a)
WHERE "table.fields"=[Forms]!["form name"]!["comboboxname"]));
You can use the expression builder to get the syntax right.
You will also need to write some code in the afterUpdate event of combobox1 to requery combobox2 everytime you pick a value.
Im not sure on the syntax
hope this helps
I will give it a try. Thanks Nerdy Girl!