need some code

[Dakota]

I have a form with a calander pop up, we use this form to
sign up for vacations. It will not let you delete out a
day earlier then todays date. A person figured out that
to do that just go to the calander for that day and pick
another day . We have a table that tracks when they
delete days, but this isn't deleteing it is changing days
is there any way to "lock" the calendar after somebody
puts a day in for that day? or would it be easier to just
track when they do that? Either way i am stuck on the VB
code that would do it.


Any help at all would be appreciated


Thanks
Dakota

 

[tina]

changing the form's AllowEdits property to No should work - unless you need
to be able to make other "existing record" changes in that form.
or, to be a little pickier, you could set the form's OnCurrent event to a
procedure, as

Me.AllowEdits = Not (DateFieldName < Date)

hth