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.
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.