Filling in a text field with data from another

[Lindopski]

This is simple Access but I am quite simple so help would be cool
all I want to know is how to put text from one field into another, but not every time.
lets explain
I have an order form and two fields , one date booked , and one date requested.
if date booked is empty I want to copy the info from date requested to it, if its full I want Access to say its already booked.

its porbably something along the lines of where datebooked.txt = "nothing" then datebooked.txt = date requested.txt or something like that anyway

 

[Smart]

REFilling in a text field with data from another

In the on load event of your form;

if nz([datebooked],"") = "" then
[datebooked] = [daterequested]
else
msgbox "This date has already been booked",vbinformation,"Already Booked"
end if