Command button to input data in a table

[wilsgaard]

I'm a rookie in access programming, so I need some basic help.



I need a command button to input data into certain fields in a table.

Example:

I have a table (Table1) with four fields: Field1, Field2, Field3 and Field4.

A form (Form1) is linked to Table1. In the form I have two buttons: Button1 and Button2.

When I click Button1, I want it to input the following data in the last record in Table1:

Field1 = 1, Field2 = 0, Field3 = 0, Field4 = 0.

When I click Button2, I want it to input the following data in the last record in Table1:

Field1 = 0, Field2 = 1, Field3 = 0, Field4 = 0.

Can anyone help with this?

[June7]

These are your actual field names? Recommend you create names that are more meaningful.

More than one way to do this, depends on the structure of form. Is this form bound to Table1? Are these fields included in the form's RecordSource? Then simply:
Me!Field1 = 0