using query to populate combo box but wont update

[willmafingerdo]

I am trying to set up my report where i can pick a date on my form and based off that the next combo box will query all codes that match that date. below is the query criteria for pulling the codes. When i an in the query itself it works, but when i run it from my form it does not refresh when i change the date field. is there a refresh or something i need to do??

[Micron]

When a value changes in a control, the control that relies on that value needs to be requeried. You could use the after update event of the 1st control to requery the dependent control. You could also do it at the form level using requery, recalc or refresh methods, but that would affect the whole form and might cause issues. So try using the after update event of the 1st control.

[willmafingerdo]

Micron,
Thanks, that fixed it. I was trying to do the refresh on the 2nd control. That seems to be working now!! ty!!

[Micron]

You're welcome!

[Gicu]

Just as a side note I always refresh a control that is dependent on other control(s) or an external parameter(s) in its own GotFocus or Enter event; it saves me adding the requery line to all the other control AfterUpdate events.

Cheers,

[Micron]

I'm not following. You're adding a requery to an event (e.g. gotFocus) for every calculated control? How is that saving any coding? Isn't it still a 1 for 1 thing?
Or are you saying you're doing 2 or more different afterUpdate events that requery the same one dependent control?

[Gicu]

Yes, it is still 1 to 1 in most cases but sometimes a combo depends on an "external" parameter such as a global variable or tempvar being changed in another place, so doing it just as you enter the control would catch all of those; and sometimes the calculated control depends on more than one other control so instead of adding the requery in each of the afterupdate events for all those controls I add it to the target control itself.