Change back to no on close

[dmkeith2]

I plan to add a PrintMe column (Yes/No) to my main table so that only
certain records will be printed.

How do I change the values back to No when I close the form which is
based on a query based on the table.

Thanks for your help.

[Rick Brandt]

dm******@hotmail.com wrote:

I plan to add a PrintMe column (Yes/No) to my main table so that only
certain records will be printed.

How do I change the values back to No when I close the form which is
based on a query based on the table.

Thanks for your help.

CurrentDB.Execute "UPDATE TableName SET FieldName = 0", dbFailOnError

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Alan Webb]

Rick,
That will update every row in the table. I believe a change to your SQL is
needed to add a WHERE clause so it only updates the row or rows that DMKeith
wanted updated. Something like, "WHERE MainTable.RowID=888".

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:0t*****************@newssvr12.news.prodigy.co m...

dm******@hotmail.com wrote:

I plan to add a PrintMe column (Yes/No) to my main table so that only
certain records will be printed.

How do I change the values back to No when I close the form which is
based on a query based on the table.

Thanks for your help.

CurrentDB.Execute "UPDATE TableName SET FieldName = 0", dbFailOnError

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Rick Brandt]

Alan Webb wrote:

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:0t*****************@newssvr12.news.prodigy.co m...

dm******@hotmail.com wrote:

I plan to add a PrintMe column (Yes/No) to my main table so that
only certain records will be printed.

How do I change the values back to No when I close the form which
is based on a query based on the table.

Rick,
That will update every row in the table. I believe a change to your
SQL is needed to add a WHERE clause so it only updates the row or
rows that DMKeith wanted updated. Something like, "WHERE
MainTable.RowID=888".

The OP indicated that the Yes/No field is used to determine which records in the
table will be printed. After printing it sounds to me like he would want all of
those fields reset. Otherwise yes, some kind of WHERE clause would be required.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[dmkeith2]

Basically what I got is when I select Yes only the personnel with yes
selected in the print me form will open up.

I would like after the report opens the form will close and reset the
print me field back to no.

Thanks

[dmkeith2]

Thanks for your help I got it to work.

On Close I put this in

CurrentDb.Execute "UPDATE tblMain SET PrintMe = 0", dbFailOnError

The code above also lets me do this to create a button to make all yes
or all no
CurrentDb.Execute "UPDATE tblMain SET PrintMe = 0", dbFailOnError
DoCmd.Requery

works great thanks.