Cannot refresh list when applying value to Combo Box

[DubboPete]

Hi all,

I have a form which opens up from a command button, and places a value
in a combo box (Combo0). There is also a list (List2) which refreshes
(at the moment only on AfterUpdate of the combo), detailing training
courses attended by that person.

Even though I can open the new form, populate Combo0 with the correct
value, I cannot get List2 to requery itself - unless I then go bck to
Combo0, and re-click the correct record which is already showing!

Is there a way to force Combo0 to refresh List2?

I don't want to take away Combo0's AfterUpdate property to refresh
List2, because once a user has the form open, they can then carry on
selecting other values not associated with the original OpenForm
action.

tia

DubboPete

 

[Marshall Barton]

I have a form which opens up from a command button, and places a value
in a combo box (Combo0). There is also a list (List2) which refreshes
(at the moment only on AfterUpdate of the combo), detailing training
courses attended by that person.

Even though I can open the new form, populate Combo0 with the correct
value, I cannot get List2 to requery itself - unless I then go bck to
Combo0, and re-click the correct record which is already showing!

Is there a way to force Combo0 to refresh List2?

You probably should have this already, but, if not, copy the
"refresh" code to the form's Current event: I think you
only need one line:
Me.List2.Requery

 

[DubboPete]

You probably should have this already, but, if not, copy the
"refresh" code to the form's Current event: I think you
only need one line:
Me.List2.Requery

Hi Marsh,

Got it in one!

Thanks mate

Pete