If Else commands based on Empty fields

[Sok Hong]

I just added a command button. For this command button, I
want it to check if Field1 is blank, and if so I want it
to do nothing. If Field1 has something filled in, I want
it to go to add a new record. Any clue how I can go about
programming this? Thanks.

 

[Allen Browne]

Use IsNull() to test if the field is blank.

 

[Mike Painter]

I just added a command button. For this command button, I
want it to check if Field1 is blank, and if so I want it
to do nothing. If Field1 has something filled in, I want
it to go to add a new record. Any clue how I can go about
programming this? Thanks.

Using the NZ function to check the field will check for both Null and empty
strings.
If you just want to see if it is Null you can use isNull.