Yes/No check box connected thru command button

[Guest]

I want to hav a button that will do 2 command
1) will add whatever data is on form to table
2) on that table, there is a yes/no check box, i would like to have that be
on yes,

it would be easier for me than to have a command button to do the 1 thing
and then have a check box.

please help

 

[G. Vaught]

Your form can be connected directly to the table and set as data entry.Check
the property values of the form. This will allow users to add new records
and not see the rest of the table information. Set the default value for the
yes/no in the table design to -1 or Yes. This will automatically set the
Yes/No field to Yes.

 

[Guest]

This would work if the table wasn't already populated
let me tell u what Im trying to do

I have this table where user who enters the main form will auto trigger an
append query, for table 1 to be populated. now this data has alot of data,
some that are useful and some aren't

Now ther is a subform where the user will have the chance to put comments on
any of the data they choose. @ teh end, another append table will occur. this
is where the yes/no check box come into play.
right now, i have a command button and a check button on this form
command to save all new info of that particular data and the check box to
make it append. if the check box is no, then the first table will be deleted.
whatever check box data is checked will move on.
i just want to kill 2 birds with one stone, want to have that command button
save all data + make that check box check all at once