Update List Box Automatically

[StanJx]

Hi,

I have a unbound form with 2 list boxes lstReq (reqdate,reqtime,vehiNO,vehistatus) & lstVehi(vehiNO,vehiavail). I need to update lstVehi(vehiavail=false) automatically (Maybe on timer event) according to the data in lstReq according to certain criteria(reqdate=date,reqtime=time,vehiNO=is not null,vehistatus=is null). What would be the best method to get this done? Would appreciate if anyone could help me with the code.

 

[dhookom]

I expect you could use the after update event of first list box. I typically write some code that modifies the RowSource property of the second list box based on the selections made in the first list box.

Duane
Hook'D on Access
MS Access MVP

 

[StanJx]

I need this to happen with out list box selection.

 

[MajP]

Not sure if I fully understand. But it would help if you could provide the row source of both lists. If I understand you are not filtering the second list based on the first list, but you need to update the underlying table of the second list based on the records in the first list and the current date and time. So if I understand correctly as time goes by as the availability period changes then certain records would be updated from available to not available. A timer event and an update query is likely needed, but you will need to provide more detail.