Requery Code (1 Viewer)

[Jade]

Hi There,

I have a form for employees to enter their vacation time in. I have two list boxes and one text box. The first list box 0, you pick your crew, then automacatically in List box 2, the employees names come up, then you enter your vacation time. Then it is suppose to save the record and make the text box (VacationTime) blank again.

Here is what I have so far and it is not working.
________________________________________
Private Sub List0_BeforeUpdate(Cancel As Integer)
Me.List2.Requery
End Sub
___________________________________________
Private Sub List2_AfterUpdate()
Me.CrewMember = Me.List2
End Sub
___________________________________________
Private Sub VacationTime_AfterUpdate()
DoCmd.Requery "VacationTime"
End Sub
____________________________________________

But the field Vacation Time, doesn't requery itself. Any help would be great.

Thanks,
Jen

 

[David R]

If Vacation Time is an unbound box, you could just use [Vacation Time]=""

I may be misunderstanding the question though. Is there a button they press after entering the value into Vacation Time to get the record to save, or is the save code in After_Update? If the latter I can see where a typo might make the data go awry..(not your original question, but maybe a consideration)

HTH
David R