lookups based on dropdowns

[Jonah]

I am using the following code after update of combobox
(cbxtype) to define the list in combobox (cbxsubtype).

Me!cbxSubtype.Requery

This works well except if I want to revisit the record
and change the subtype. In order to get the list to
update in the cbxsubtype I need to change the selection
in the cbxtype and then re-select the original one before
I can go to cbxsubtype and get the proper options.

Is there a way that I can get the cbxsubtype to requery
on-focus or before update?

TIA
Jona

 

[Graham Mandeno]

Hi Jonah

Just add the same line of code (Me!cbxSubtype.Requery) to your form's
Form_Current event procedure.

 

[Marshall Barton]

I am using the following code after update of combobox
(cbxtype) to define the list in combobox (cbxsubtype).

Me!cbxSubtype.Requery

This works well except if I want to revisit the record
and change the subtype. In order to get the list to
update in the cbxsubtype I need to change the selection
in the cbxtype and then re-select the original one before
I can go to cbxsubtype and get the proper options.

Is there a way that I can get the cbxsubtype to requery
on-focus or before update?

Check your other thread on this question where I tried to
address it.