My main form has a timervalue 'On timer' property set.
I am using the timer property to cause a little red box to 'Flash' I simply hide it then unhide it. The timervalue is set to 1000 so it flashes every second. The Timervalue is only set if there are dates in a reminder table. If there are no dates the ONTIMER event turns the timervalue to '0'.
My problem is when I go to other forms and click on my buttons that say "Add New Record" it adds a record to my MAIN form not the form I currently have open. Sometimes I get error 2465. I have tried setting my new forms to Modal, this doesn't work. I tried setting the focus to a field on my current form then "add new record' this also didn't work.
Through hours of frustration I determined that If I
change the timervalue to '0' when I open subforms this resolves the issue. Am I missing something? Is there a better way to cause something to "Flash"? I will happily abandon the "ontimer" idea if there is a better way to do it.
Please help.
I am using the timer property to cause a little red box to 'Flash' I simply hide it then unhide it. The timervalue is set to 1000 so it flashes every second. The Timervalue is only set if there are dates in a reminder table. If there are no dates the ONTIMER event turns the timervalue to '0'.
My problem is when I go to other forms and click on my buttons that say "Add New Record" it adds a record to my MAIN form not the form I currently have open. Sometimes I get error 2465. I have tried setting my new forms to Modal, this doesn't work. I tried setting the focus to a field on my current form then "add new record' this also didn't work.
Through hours of frustration I determined that If I
change the timervalue to '0' when I open subforms this resolves the issue. Am I missing something? Is there a better way to cause something to "Flash"? I will happily abandon the "ontimer" idea if there is a better way to do it.
Please help.