I have spent over 6 hours on this God forsaken form and I need to stop.
I have a fairly simple database. A table of employees, A table of workdays, and then a shift table which joins employees to which days they worked and what hours.
I have a form. It's a multi record form. Basically I want the user to specify a date in a field and then the form will display all shifts from that day. I can't figure out how to do this to save my life.
Now to my question. I have an unbounded textbox that is set to take a date. In the Lost Focus event, I put the command, Me.Refresh. Nothing happens. So then I put MsgBox "Blah", , "Reminder" just to verify that the event is firing. Nothing. Can someone please help? This absolutely can't be that hard that a graduate Computer Science student can't figure out.
Thanks a million...
I have a fairly simple database. A table of employees, A table of workdays, and then a shift table which joins employees to which days they worked and what hours.
I have a form. It's a multi record form. Basically I want the user to specify a date in a field and then the form will display all shifts from that day. I can't figure out how to do this to save my life.
Now to my question. I have an unbounded textbox that is set to take a date. In the Lost Focus event, I put the command, Me.Refresh. Nothing happens. So then I put MsgBox "Blah", , "Reminder" just to verify that the event is firing. Nothing. Can someone please help? This absolutely can't be that hard that a graduate Computer Science student can't figure out.
Thanks a million...