input text in a field automattically

bseche

Registered User.
Local time
Today, 02:54
Joined
Aug 13, 2001
Messages
26
I want to write a code where it looks at a field called Box number if the box number field is blank then it will go to another field call Storage and enter " No box number for storage" Please help
It should be something similar to if isnull then go to the field and enter the following text. I just don't know how to set it up

Thanks much
 
Private Sub Command0_Click()
DoCmd.RunSQL ("UPDATE [Table1] SET [Table1].[Storage] = 'No box number for storage' WHERE [Table1].[Box] Is Null")

End Sub
 
Thank you for the reply, how would i go about once they do enter something in the box number i want the Not yet in storage to go away.
 

Users who are viewing this thread

Back
Top Bottom