Simple (hopefully) Checkbox vailidation.

[Homegrownandy]

I have a costing form attached to every job I have. At the top of this form there is a checkbox for 'obtained costs'. The user should click this once all of the additional costs are entered (the job will then be removed from jobs that require cost information.)

I would like to attach a message box to this if the user hasn't entered any cost information in the "Txtcost" text box. Just so they are aware they didn't enter the value basically.

I can get a message box to work on update, but not depending on another text box's value.

Hope I've explained what I'm after well enough.

Thanks.

[June7]

Record validation code customarily goes in the form BeforeUpdate event.

[Homegrownandy]

Okay, Im pretty useless with VBA/ coding. Would you be able to suggest some?

The value is currency, If it =0 then msg box appears when checkbox is clicked.


I don't want the form to validate anything. I want the users to be able to enter this information as and when they please. before or after the update doesn't really make a difference. because I want them to have the ability to enter 'wrong' information as long as they are aware they are doing so.

just to confirm, its the checkbox I want to add the validation to.

[June7]

Then the validation is just to check whether or not the textbox has a value. Is textbox bound to a number type field?

What do you want to happen if the checkbox is checked (True) and what if the checkbox is unchecked (False)?

Suggest using the checkbox Change event, something like:

If Me.checkboxname = True Then
If IsNull(Me.textboxname) Or Me.textboxname = 0 Then
MsgBox "say something"
End If
End If

[Homegrownandy]

Thanks a lot. I know these are simple questions regarding VBA. I intend to spend some time learning at least the basics. Even that was a 50 hour series on youtube haha.

the textbox is bound to a currency field, and the checkbox is basically just to take the job off a query (marks it as done).

The query will show all completed jobs that do not have this true value. These can then be dealt with and once complete ticked off.