CHECK BOX Enables record per selection in continus form???

[BRASILO]

Hello,

I need help with the following:



I have a continuous form that has a check box and 5 fields in a continuous form. I'm attempting to get this check box to only enable the record for edit as you check the check box next to the record line. However, when you check or uncheck the box all the records open for edit, to include the ones whos check box was not checked. Please help.

The following code is what I have:

        With Me.Recordset
        Do While Not .EOF
            If Me.cmBOX = 0 Then
            Field1.Enabled = False
            Field2.Enabled = False
            Else
            Field1.Enabled = True
            Field2.Enabled = True
            End If
        Loop
    End With

[pbaldy]

Code like that won't work on a continuous form. Look at Conditional Formatting on the ribbon.

[BRASILO]

Code like that won't work on a continuous form. Look at Conditional Formatting on the ribbon.

I see I ended up trying this instead. However, all my other records update as well. I'm trying to only update the records that I select.

Dim db As DAO.Database
Dim rs As DAO.Recordset
If cmBOX= True Then
Set db = CurrentDb()
Set rs = db.OpenRecordset("QRY_DataTBL", dbOpenDynaset)
rs.FindFirst "ID = '" & Me.ID & "'"
rs.Edit
rs!conCOMMENTS = Me.conCOMMENTS
rs!IScomments = Me.IScomments
rs.Update
End If
Me.Requery
rs.Close
Set rs = Nothing
Set db = Nothing

[pbaldy]

That looks like a completely different issue. That looks like it would update a single record. From the sound of it, I'd use an update query like on your other thread. I hope you're not in a multi-user environment, as using a checkbox in the data to select records could be problematic.

[BRASILO]

That looks like a completely different issue. That looks like it would update a single record. From the sound of it, I'd use an update query like on your other thread. I hope you're not in a multi-user environment, as using a checkbox in the data to select records could be problematic.

I'm hoping to do both in one. When the check box is selected, the other records can't be edited only the checked one will allowed to be edited and posted to the tbl. However, i'm not getting anywhere....

[BRASILO]

That looks like a completely different issue. That looks like it would update a single record. From the sound of it, I'd use an update query like on your other thread. I hope you're not in a multi-user environment, as using a checkbox in the data to select records could be problematic.

I think I'm close, on my QRY, I have the a Where statement that equals yes. So only that checked one should go through. However, if I type info in the other fields that are not being "grayed out" They update as well.....

[pbaldy]

Well, they're different. Your first post would allow the user to edit. Your second is actually doing the editing. If you want to edit multiple records with that text, use an update query like the other thread but with a criteria on the Yes/No field.

[BRASILO]

Well, they're different. Your first post would allow the user to edit. Your second is actually doing the editing. If you want to edit multiple records with that text, use an update query like the other thread but with a criteria on the Yes/No field.

Any suggestions as to how I can restrict the fields unless selected?

[pbaldy]

Along the lines of

strSQL= "UPDATE TableName SET conCOMMENTS= '" & Me.conCOMMENTS & "' WHERE YesNoField = True"
CurrentDb.Execute strSQL

[Micron]

You can decipher which record a user selects on in a continuous form even if all controls are disabled, as long as there's a way to select or navigate to a record. That might only be the default record navigation on the left side of the form, or keyboard input. The form Current event can get the value of any field, which you can then use as criteria in an Update query. No check boxes or buttons are needed, although I suppose you'd need an input form to permit the user to edit only the fields you allow.

Alternatively, set the control(s) to be enabled but locked. Then they can be clicked on but not edited, thus you can know which control and what value it contains. I suppose there are many other ways to arrive at the desired result as well. Again, some type of edit form would be required.

[BRASILO]

You can decipher which record a user selects on in a continuous form even if all controls are disabled, as long as there's a way to select or navigate to a record. That might only be the default record navigation on the left side of the form, or keyboard input. The form Current event can get the value of any field, which you can then use as criteria in an Update query. No check boxes or buttons are needed, although I suppose you'd need an input form to permit the user to edit only the fields you allow.

Alternatively, set the control(s) to be enabled but locked. Then they can be clicked on but not edited, thus you can know which control and what value it contains. I suppose there are many other ways to arrive at the desired result as well. Again, some type of edit form would be required.

Thank you for the detailed help. I ended creating a second form that populates with the selection. from testing it seemed like the better way to get it done.