I am stumped. HELP !!!

[Ayo]

This is my situation. I have 2 option buttuns: Select All and Make Selection.
And I have about, 6 checkboxes and 6 comboboxes next to them.
The way it is supposed to work: I click on Select All, all the checkboxes
are selected and the comboboxes rowsource are assigned something like this:
"SELECT DISTINCT [CONSTR MGR] FROM [tblConstruction_Tracker] ORDER BY [CONSTR
MGR]". I click on Make Selection, then I click on any checkbox and the
corresponding combobox rowsource is assigned something like this: "SELECT
DISTINCT [CONSTR MGR] FROM [tblConstruction_Tracker] ORDER BY [CONSTR MGR]".
The way it is actually work: The Make Selection scenario works fine but the
Select All works by checking all the checkboxes but there is nothing in the
combobox to select. This is my problem. Any I have tried evrything I know to
resolve this.
I have been working on thisnow for about 2 days now. If anyone out there
know and easy and quicker way of doing this please help.
Thanks

 

[Conan Kelly]

Ayo,

In your "Select All" button code, do you refresh/requery each control after
setting the rowsource?

It has been a while since I've worked on forms/reports in Access, but if I
remember correctly, you want to requery or refresh the control.

After the line where you set the rowsource for the control, put a line in
that will requery/refresh the control:

ComboBox1.Requery
OR
ComboBox1.Refresh

Make sure to type it in. After you type in the period/dot/decimal point,
the VBE should show a list of properties/methods available for that control.
The typing the "re" will take you down the list to all of the
propties/methods that begin with "Re". Look through there and see if
Requery or Refresh is in the list. You might want to try each one (or look
them up in Help) to see what the difference is.

HTH,

Conan

 

[Ayo]

Thanks for the insight. I was able to figure out anthoer way to do what I
needed to do.

Ayo,

In your "Select All" button code, do you refresh/requery each control after
setting the rowsource?

It has been a while since I've worked on forms/reports in Access, but if I
remember correctly, you want to requery or refresh the control.

After the line where you set the rowsource for the control, put a line in
that will requery/refresh the control:

ComboBox1.Requery
OR
ComboBox1.Refresh

Make sure to type it in. After you type in the period/dot/decimal point,
the VBE should show a list of properties/methods available for that control.
The typing the "re" will take you down the list to all of the
propties/methods that begin with "Re". Look through there and see if
Requery or Refresh is in the list. You might want to try each one (or look
them up in Help) to see what the difference is.

HTH,

Conan

This is my situation. I have 2 option buttuns: Select All and Make
Selection.
And I have about, 6 checkboxes and 6 comboboxes next to them.
The way it is supposed to work: I click on Select All, all the checkboxes
are selected and the comboboxes rowsource are assigned something like
this:
"SELECT DISTINCT [CONSTR MGR] FROM [tblConstruction_Tracker] ORDER BY
[CONSTR
MGR]". I click on Make Selection, then I click on any checkbox and the
corresponding combobox rowsource is assigned something like this: "SELECT
DISTINCT [CONSTR MGR] FROM [tblConstruction_Tracker] ORDER BY [CONSTR
MGR]".
The way it is actually work: The Make Selection scenario works fine but
the
Select All works by checking all the checkboxes but there is nothing in
the
combobox to select. This is my problem. Any I have tried evrything I know
to
resolve this.
I have been working on thisnow for about 2 days now. If anyone out there
know and easy and quicker way of doing this please help.
Thanks