Form, existing records and some fieds to fill up. Need to verify if a field is not null

  • Thread starter Thread starter Céline Brien
  • Start date Start date
C

Céline Brien

Hi,
A form with existing records with some fields alresay fill up and other
field to fill up.
I need to verify if the field Consultant is fill up.
Something like that :
-------------------------------------------
Private Sub Form_AfterUpdate()
If Me.Consultant Is Null Then
MsgBox ("Vous devez remplir le champ Consultant"), vbOKOnly, "Remplir le
champ Consultant"
??? Go back to Record and the field Consultant ???
End If
End Sub
 
On before update event of your form check the value of Consultant as
like

If Nz(Me.Consultant)="" Then ' if Consultant is a text data type or
If Nz(Me.Consultant)=0 Then ' if Consultant is a number data type

MsgBox "Vous devez remplir le champ Consultant", vbOKOnly, "Remplir
le champ Consultant"
Cancel=True
Me.Consultant.SetFocus

End If
 
I think...

Me.Consultant.SetFocus

....will do what you want...

Ross La Haye
 
Thank you for your answer.
It is working perfectly !
Have a good day.
Céline
 
Thank you for your answer.
Me.Consultant.SetFocus is doing the job !
Have a good day.
Céline

"Klein-4" <[email protected]> a écrit dans le message de (e-mail address removed)...
I think...

Me.Consultant.SetFocus

....will do what you want...

Ross La Haye
 
You're welcome. :-)

Ross La Haye

Céline Brien said:
Thank you for your answer.
Me.Consultant.SetFocus is doing the job !
Have a good day.
Céline

"Klein-4" <[email protected]> a écrit dans le message de (e-mail address removed)...
I think...

Me.Consultant.SetFocus

...will do what you want...

Ross La Haye
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DMax on existing record to increment serialized # fails 1
In a sub-form : when entering a field, verify if another field is true, if so show a MsgBox + set fo 4
Filling in fields to a partially complete record in a table using a form 0
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Excel Need assistance with modifying a Duplicate declaration. 13
Form fields don't need to always be filled in 1
Navigate to record on a form and turn on and off fields 4
Checking value of a Null field 3

Back
Top