I have created a simple invoice screen to use to sell drinks when we go to different events. So I would like to have the same client for that day without having to enter it each time.
Thanks
I have created a simple invoice screen to use to sell drinks when we go to different events. So I would like to have the same client for that day without having to enter it each time.
Thanks
something like this in the form beforeupdate event
clientID.DefaultValue = Nz(clientID)
where clientID is the name of the control on the form which the user selects a client
if clientID is text, then it would be
clientID.DefaultValue = """" & Nz(clientID) & """"
Edit: you will probably then want to lock the control so users cannot change it in which case in the same event add the code
clientID.Locked=true
To unlock, close and reopen the form
Thanks Ajax, I will give it a go.