D
Darryn
Hi all
I have a number of check boxes on a form which are used the toggle the
enabled status of other controls (I want to disable input into certain
fields if it is not required by the user). I have this working fine
using the following two event proceedures, so when a new record is
being entered the user checks the boxes and the fields are enabled.
Private Sub IsUnique_AfterUpdate()
If Me.IsUnique = True Then
Me.Quantity.Enabled = False
Me.SerialNumber.Enabled = True
Else
Me.Quantity.Enabled = True
Me.SerialNumber.Enabled = False
End If
and
Private Sub YearColourCoded_AfterUpdate()
Me.cboYearColourCode.Enabled = Me.YearColourCoded
End Sub
When I am navigating back through saved records the checkboxes are
still checked but the other controls are being disabled. Is there any
way to refresh or requery the check boxes when a record is reloaded.
I have tried to add the following
Me.Requiresmaintenance.Requery
Into the on current and on load event in the forms property
but it has had no effect and I am at a loss to work out how to do it
Thanks
Darryn
I have a number of check boxes on a form which are used the toggle the
enabled status of other controls (I want to disable input into certain
fields if it is not required by the user). I have this working fine
using the following two event proceedures, so when a new record is
being entered the user checks the boxes and the fields are enabled.
Private Sub IsUnique_AfterUpdate()
If Me.IsUnique = True Then
Me.Quantity.Enabled = False
Me.SerialNumber.Enabled = True
Else
Me.Quantity.Enabled = True
Me.SerialNumber.Enabled = False
End If
and
Private Sub YearColourCoded_AfterUpdate()
Me.cboYearColourCode.Enabled = Me.YearColourCoded
End Sub
When I am navigating back through saved records the checkboxes are
still checked but the other controls are being disabled. Is there any
way to refresh or requery the check boxes when a record is reloaded.
I have tried to add the following
Me.Requiresmaintenance.Requery
Into the on current and on load event in the forms property
but it has had no effect and I am at a loss to work out how to do it
Thanks
Darryn