M
Michael
I can't believe I'm having this problem. I have two combo boxes on a form.
The RowSource for ComboBox2 selects records based on the value selected in
ComboBox1.
For the AfterUpdate event of ComboBox1, I've tried saving the record,
requerying ComboBox2 (ComboBox2.requery and docmd.requery "ComboBox2") and I
can't get ComboBox2 to requery. It keeps the records from the prior value of
ComboBox1. Only when I physically change records and come back again does
ComboBox2 properly requery.
Any ideas?
Thanks,
Michael
The RowSource for ComboBox2 selects records based on the value selected in
ComboBox1.
For the AfterUpdate event of ComboBox1, I've tried saving the record,
requerying ComboBox2 (ComboBox2.requery and docmd.requery "ComboBox2") and I
can't get ComboBox2 to requery. It keeps the records from the prior value of
ComboBox1. Only when I physically change records and come back again does
ComboBox2 properly requery.
Any ideas?
Thanks,
Michael