[RESOLVED]How to add a data to a field on clicking a button

Hi,

How can I set a field value (Yes no Type) by click on a button in a form in Access ???, the form derives its data from a table where all the fields are defined...

thanks
arunb

Moved to Office Development

Is it a bound control, or in code? If bound, use a checkbox instead of a button, if you can. If not, say you don't display the value, try code (DAO, which is faster if you're staying in Access, & not in VB6, .Net, etc):
[/Highlight]
strSQL = "UPDATE tblFoo SET fldYesOrNo = True WHERE ID = 999"
DoCmd.RunSql strSQL
[/Highlight]
Change the names to whatever is appropriate