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?