i want each continous form instance to be independent

[Naqibullah]

Dear colleagues,
please help me out, i want continuous form so that i can know what my prvious record is, but this gives me trouble i have some check boxes that based on some conditions they disable some fields, but when i do this on the first record, the same happens in coming forms for data entry, for example i check check box A and it disables field B and combo C, but for next record i may not check check box A may be it will be unchecked, but it continous form it doesn't allow me it automatically happens for all

 

[nickthompson]

I presume the checkboxes are unbound? If they were bound to a field they wouldn't do this. You may not be binding them because you don't want to store the values in them - they're just for a temporary need like selecting records to view. If that's the case, perhaps add a field to your table and bind them anyway just to get around this problem. They're only boolean values so won't have any significant effect on your database's performance. Alternatively, google 'Albert D. Kallal multi select' and see his demo of a workaround.

 

[Naqibullah]

No my all check boxes are bound to different fields in the table, please see the snap shot

 

[JHB]

Normally in continuous form, if you change a controls property it would be for them all. Only if you use "Conditional formatting" you are able to do what you want.
Do you have some code running or how did you set it up?

 

[nickthompson]

I think I understand the issue better now.

Are all the checkboxes bound? Or just the NoCase one?

The trouble is that in Access you cannot refer to an instance of a control within a specific record. Every instance of that control in every record has the same name.

If the other two checkboxes are not bound then you could consider binding them (as described earlier). Then rather than updating the checkboxes by referring to the control name, you update the value stored in the record and requery the form.

 

[Naqibullah]

Following is the code for NoCase check box, if it is chekced the two other checkboxes and combo boxes are disabled otherwise they are enabled,

Private Sub NoCase_AfterUpdate()
If Me.NoCase.Value = True Then
Me.Followup.Enabled = False
Me.TypeOfCase1.Enabled = False
Me.NewCase.Enabled = False
Me.TypeOfCase2.Enabled = False
Else
Me.Followup.Enabled = True
Me.TypeOfCase1.Enabled = True
Me.NewCase.Enabled = True
Me.TypeOfCase2.Enabled = True
End If
End Sub

 

[Naqibullah]

i didn't understand this point (
Then rather than updating the checkboxes by referring to the control name, you update the value stored in the record and requery the form.)
as i mentioned before all these three check boxes i am talking about are bound

 

[JHB]

Following is the code for NoCase check box, if it is chekced the two other checkboxes and combo boxes are disabled otherwise they are enabled,

Private Sub NoCase_AfterUpdate()
If Me.NoCase.Value = True Then
Me.Followup.Enabled = False
Me.TypeOfCase1.Enabled = False
Me.NewCase.Enabled = False
Me.TypeOfCase2.Enabled = False
Else
Me.Followup.Enabled = True
Me.TypeOfCase1.Enabled = True
Me.NewCase.Enabled = True
Me.TypeOfCase2.Enabled = True
End If
End Sub

Sorry - you can't do it in this way.