Ok, I have been running myself in circles trying to figure this out, and am hoping there is a not-too-complicated answer. (I'm not exactly an Access guru yet!)
Here is what I would like to happen:
When the database is started, or the switchboard opens, an automatic check runs that checks a date field against the current date. If they are equal, a field in the same table updates to "Available". The combo-box that displays this field will also update on the forms.
I currently have the code attached to the form, using OnCurrent, and it works, but only when you scroll through each record. I need it to check automatically for all records. I've tried a few differnt "until EOF" type things, and nothing has quite worked. Any suggestions would be greatly appreciated!!
Here is what I would like to happen:
When the database is started, or the switchboard opens, an automatic check runs that checks a date field against the current date. If they are equal, a field in the same table updates to "Available". The combo-box that displays this field will also update on the forms.
I currently have the code attached to the form, using OnCurrent, and it works, but only when you scroll through each record. I need it to check automatically for all records. I've tried a few differnt "until EOF" type things, and nothing has quite worked. Any suggestions would be greatly appreciated!!
