I read somewhere in the forum that when you click on one field, it goes to another field and add a backgroun color to that filed or flag it or something on that term. Example: click or fill in a date close date, then the status field light up with a different color. Not putting any information in the field just highlight to another color. I have search all the way backe to June of 2002, I just cannot find it.
I also just recently read in a thread about refresh and requery.
My requery or refresh is not working on my control source anymore. I know to go to a Before or After Update, or Exit or Enter Event, on my text or combobox - and list my macro that I want to take place when I enter that field on my form it should read that macro do an update.
I have done this a thousand times, but for some reason it is not working anymore. I have to actually get out the form, go to the query and click on it to perform an action.
example: I have a field called 'Time' when I enter 2.5 into this field it is suppose to update the 'Day' field with the correct information.
Any Help is appreciated, or just give a Thread to go to.
Thanks
Brenda
I also just recently read in a thread about refresh and requery.
My requery or refresh is not working on my control source anymore. I know to go to a Before or After Update, or Exit or Enter Event, on my text or combobox - and list my macro that I want to take place when I enter that field on my form it should read that macro do an update.
I have done this a thousand times, but for some reason it is not working anymore. I have to actually get out the form, go to the query and click on it to perform an action.
example: I have a field called 'Time' when I enter 2.5 into this field it is suppose to update the 'Day' field with the correct information.
Any Help is appreciated, or just give a Thread to go to.
Thanks
Brenda