Update Button ...

[Christopherusly]

Is it possible to update a field in a record using a VBA button ?

What i want to do is have a button on a form, which when pressed changes a certain field value from its default "no" to "yes", i am happy with how to do the yes no VBA question box .. but the code on how to udate the field ...

Any suggestions ?

 

[KenHigg]

Could you use a check box instead?

Ken

 

[Christopherusly]

Could you use a check box instead?

Ken

not really, this is an option i had considered tho.

 

[KenHigg]

In that case something like the following might work in the on click event of the button:

me!myTextBoxName = "Yes"

or

me!myTextBoxName = "No"

Or you could do something like:

If me!myTextBoxName = "No"
 me!myTextBoxName = "Yes"
Else
 me!myTextBoxName = "No"
End If

Ken

 

[Christopherusly]

I shall give that a try many thanks