Oh! Just noticed i got a promotion! Yay! Need to get a celebratory notification of some kind when that happens *hint hint* ;)

Ensign Dan

I don't remember macros so will have to advise with code, sorry. It's super simple though

Say your field name is called "Active" you just put code in to the code builder on the click event

Active = False
Me.Requery

If the requery doesn't work you can try Me.Refresh

Cheers for this Adam. Seems like a great idea but the Active = False didn't work.

Field IS called Active. All records currently have "True" set

Put the code in the onclick event procedure (See Image) but it isn't updating the field from True to False. Tried enclosing False in "" but didn't help.

Thanks!

What's the name of the control on the Form?

As Adam said - super simple to add that code. Baby steps.
That being said it will not hide the record.  You probably will need to change the underlying record source to only display the Active records.  Assuming that you field is a Yes/No field add it to your query and in the Criteria line type True (again assuming that Active is the default)

Yea, just because the field in the TABLE is called active, doesn't necessarily mean the field on the FORM is called active, it might be called Check14. In which case you would do Check14=False (Or more meaningfully, rename the checkbox)

Dan - Don't put  False in quotes.
It should just be   Active = False

Thanks Guys. I can confirm the following:

ALEX - The control is called Button_DeleteRecord

Scott 1st Reply - I've set a query up to only show records where the Active Field is set to True (I've done true/false but can be anything really). The query auto updates once the field has anything but True, and hides it. The form is based on this query.

Adam - Yep, i'm just starting in access so getting into good habits from the get go. Every so often i will go through the dropdown in the properties box and name Everything. Usually --WhatControlItIs_Subject-- for example - Text_FirstName.

Scott 2nd Reply - Yep, i did without first time and didn't work. I just wanted to try incase it was something silly. I can confirm that without the quotes, it still doesn't work.

Cheers

Your BUTTON is called Button_DeleteRecord, we want the name of the Checkbox that you want the value changed on that you added. (Unless you called your checkbox Button_DeleteRecord?)

There is no checkbox. The button is currently set to run a Macro on click to delete record

What is the Data Type of the Active field? Is it Yes/No?

Short Text

I would change the Data Type to Yes/No and if you need to display Active/Inactive on your form you can make a Calculated Query Field using an IIF Function.

I've used IF functions in Excel and understand the principal is the same but haven't gotten that far in the course yet so i'll put it on hold and revisit when i have, thanks Kevin!