G
Guest
My form has two unbound comboboxes, cbxCategory and cbxProduct. cbxCategory
gets its values from a table, and a "SELECT....WHERE...." in its AfterUpdate
event supplies the RowSource for cbxProduct. All of this works fine, but
when my continuous form first opens, both cbx's are empty and ALL the records
show. How do I do the following:
a) When the form opens, I want cbxCategory to be showing its first value
already (Dry goods), and only the matching dry-goods records should be
showing in the form. How can this be done?
b) As a second question, it would be even better if, when the form opens,
cbxCategory is on its first record (Dry-goods) and cbxProduct is on its first
matching record. What is a good way to do this as well?
thank you
gets its values from a table, and a "SELECT....WHERE...." in its AfterUpdate
event supplies the RowSource for cbxProduct. All of this works fine, but
when my continuous form first opens, both cbx's are empty and ALL the records
show. How do I do the following:
a) When the form opens, I want cbxCategory to be showing its first value
already (Dry goods), and only the matching dry-goods records should be
showing in the form. How can this be done?
b) As a second question, it would be even better if, when the form opens,
cbxCategory is on its first record (Dry-goods) and cbxProduct is on its first
matching record. What is a good way to do this as well?
thank you