Button click to update field in table

Hi,

On one of my forms I need a button that when clicked on would update a field in a table. Is this possible?

Thanks in advance

Steve

Of course it is possible.

Just put the button on the form and edit its ON CLICK property.

If the controls source is a query or a table just enter this:

Private Sub MyButton_Click()
MyField.Requery
End Sub

or if the field has no recordsource you can assign any values like the followings:

Private Sub MyButton_Click()
MyField.Value = "Anything you want"
End Sub

and so on.


Hope this helps