Tick Box condition

[RiskyP]

Hi,

Never posted here before. I'm pretty good as an excel user so thought writing VBA for access would be the same. However i've become pretty stuck.

I have a single table for all the data in my database, and a number of forms that users can use to edit this data. One of these froms is a continuous form that the user opens to tick a box to display weather certain objects have been shipped (have used a continous form as several objects are usual dispached at the same time). What i would like to do is, once the tickbox is checked, to overwrite data in my 'location' field to shipped for all ticked records. Have tried several different ways but to no avail

Many thanks,
RiskyP

 

[Trevor G]

Welcome to the forum, open the form in design view then select the checkbox and open the properties and look at the Event Tab, then select the On Click Event and you would then use the 3 dots to the right and select Code Builder, you then add an IF Statement to do something like this:

IF Me.chkName = True Then
ME.location="shipped"
End IF

 

[John Big Booty]

As an addendum to Trevor G's post. Check boxes can also be tested for -1 or "Yes" as well as True when checked and 0, "No" or False when unchecked.

 

[RiskyP]

Thank-you to both posters, very helpfull!