Select all for a checkbox

[d13rosew]

I have a form that was created by another user long ago... I need to add a button that when clicked it checks all check boxes on the form. The form is currently per loaded by a different query. For this form when the user checks the box for each line items it will load a different table once you click a done button on the form. What is the best way to go about this. I am fairly new to this type of Access programming.

[June7]

What do you mean by 'all' checkboxes? There are multiple yes/no fields bound to checkbox controls? Or do you mean one field/checkbox and multiple records?

I have no idea what you mean by 'load a different table'.

[d13rosew]

it is one field/checkbox and multiple records? By it loads a different table I am talking about that is the box next to the record is checked a different table is loaded with the other data in the form. If the checkbox is not checked then no data is loaded.

Thank you for any guidance you can provide.

[June7]

Load data from table to where? Why would data come from various different tables?

Is this checkbox unbound? An unbound control will show the same value for all records.

Sorry, still not making sense to me.

[d13rosew]

Sorry, i'm not very fimilar with this database as I didn't create it and i'm trying to fix the issues in it. So i'm having to do a lot of digging to find how it was set up. This might help the code attached to the checkbox on the form is below. I want to have all the records that are loaded be loaded as checked so the user doesn't have to go and check them all one at a time. I hope this helps

Private Sub chkCompleted_Click()
If Me.chkCompleted = -1 Then
Me.txtNMFCancelDate = Date
Else
Me.txtNMFCancelDate = Null
End If
End Sub

[June7]

That code has nothing to do with setting the checkbox. It is only triggered when the checkbox is clicked. And the code sets value in txtNMFCancelDate.

So what you really seem to want is to set value in txtNMFCancelDate.

Simplest way to do this is with an UPDATE sql action. What is the identifier that relates these records? Something like:

CurrentDb.Execute "UPDATE tablename SET fieldname=Date() WHERE ID=" & Me!ID

Then refresh the form with Me.Refresh.

However, real trick is figuring out what event to put the code in.

[d13rosew]

Thank you this helps a lot. There are a lot of rabbit holes i'm running down on this database. Wouldn't it be easier just to add a button function to click and make all the checkboxes checked? That is what I was hoping would be the fastest solution but i'm having trouble making that happen.... I've never set up a "check all" type of button before.

[June7]

The UPDATE action is still easiest and can be in the button Click event. Checking each record would require looping code. And programmatically setting the checkbox will not set value in the date textbox.

[d13rosew]

Ok, thank you for all your time