Not updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have a form in Access 2003 in which a user can select one of
three check box options and when one is selected the other two are greyed out
and you cannot select them.
I have found a problem where if a user searches for a record and selects one
of these boxes, and then searches for anothe record, the previously selected
box is the only one available for selection unless you click on that and then
click off it to make the others available.
Is there a method of gettign arouind this,
Matt
 
From your description, your check boxes are unbound controls, so they
do not change from one record to the next.

You could clear (enable?) the three check boxes in the on-current event
of the form.

John
 
The check boxes are bound and they give the correct reading, i.e. unchecked
or checked, but not all of the options are available for selection.

I have nothing in the oncurrent event of the form, the related information
for the check boxes are in the onclick event of each one e.g.

If Me![Quote Not Sent] = 0 Then '-- CheckBox is unchecked!
Me![Reasons].Enabled = False
Else '-- CheckBox is checked
Me![Reasons].Enabled = True
End If

Matt
 
Hi -

When you disable a control, it stays disabled until it is enabled again,
even if you move to another record; in your example, [reasons] will stay
enabled/disabled until it is changed. But since whether [reasons] is
enabled or not depends on whether or not [quote not sent] is true, and
since [quote not sent] is bound, then you need to reset [reasons] (and
others like it) in the On Current event:

me![reasons].enabled = me![quote not sent]

should do it (works because [quote not sent] is true/false)

You do need to keep the on-click code though, to handle changes you may
make.

John

P.S. Did you think about what to do if [reasons] contains data, and then
you set [quote not sent] to false? Just a little logical loophole to
think about over coffee++ !

J.


Matt said:
The check boxes are bound and they give the correct reading, i.e. unchecked
or checked, but not all of the options are available for selection.

I have nothing in the oncurrent event of the form, the related information
for the check boxes are in the onclick event of each one e.g.

If Me![Quote Not Sent] = 0 Then '-- CheckBox is unchecked!
Me![Reasons].Enabled = False
Else '-- CheckBox is checked
Me![Reasons].Enabled = True
End If

Matt

:

From your description, your check boxes are unbound controls, so they
do not change from one record to the next.

You could clear (enable?) the three check boxes in the on-current event
of the form.

John
Click to expand...
Click to expand...
 
Back
Top