Enabled/Disabled in a continuous form

[Lister]

Right got another for you all.

This time I am trying to use an option group in a subform.
If the user selects [On_Going] I would like the date/time field [dtmBYWHEN] to be disabled.
And, conversely, if the [Limited Time] option is selected, [dtmBYEWHEN] will be enabled.
To be honest visable = True/False would be fine.
The small field at the bottom hold the value stored by the option group. [intOnGoing_Date]

At the moment it doesn’t seem to matter which is selected. All the records in this sub form are either Enabled or Disabled, depending on my code.

Anyway my code for this subform is…

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_ErrorHandler

Dim intHoldNum As Integer

intHoldNum = Me.intOnGoing_Date

If intHoldNum = 1 Then
Me.dtmBYWHEN.Enabled = False
Else
Me.dtmBYWHEN.Enabled = True
End If

Exit_ErrorHandler:
Exit Sub

Err_ErrorHandler:
    MsgBox Err.Description, vbExclamation, "Error #" & Err.Number
    Resume Exit_ErrorHandler
End Sub

Now I am using a continuous form. Is this my problem?
If it is, is there any way around this proble?

Thanks guys

 

[Rich]

you'll have to use something like this example
http://www.access-programmers.co.uk/forums/showthread.php?t=72070

 

[Lister]

Thanks Rich, looks like I am buggered in that regard.
No big thing, I will just have to work my way around.

Thanks