J
Jay
Hi all,
Have a question about combo boxes. I have a combo box that has a Row Source
Type: Table/Query and a Row Source as a query I wrote. Just lists all
(distinct)part numbers so the user can see what's available to choose.
Under that combo box I have a check box which the user can click if he wants
to see all part numbers. The form is just a portal to another form, so
there's no updating the combo box source. The check box just disenables the
combo box.
My issue is, when I switch to Design mode, often the check box is checked
but the combo box is still enabled. Or the item I selected the last time I
ran the form is still selected when I rerun the form.
I have a default value of 0 for the check box but it doesn't seem to matter.
Do I need to code the default values in the FormLoad? Is there a reason
values are being retained between occasions of running the form in design
mode?
I think that's it. Any help is appreciated.
Jay
Have a question about combo boxes. I have a combo box that has a Row Source
Type: Table/Query and a Row Source as a query I wrote. Just lists all
(distinct)part numbers so the user can see what's available to choose.
Under that combo box I have a check box which the user can click if he wants
to see all part numbers. The form is just a portal to another form, so
there's no updating the combo box source. The check box just disenables the
combo box.
My issue is, when I switch to Design mode, often the check box is checked
but the combo box is still enabled. Or the item I selected the last time I
ran the form is still selected when I rerun the form.
I have a default value of 0 for the check box but it doesn't seem to matter.
Do I need to code the default values in the FormLoad? Is there a reason
values are being retained between occasions of running the form in design
mode?
I think that's it. Any help is appreciated.
Jay