Rookie - Easy way to filter combo box in DS/CF View - SQL Server

[Atlas]

Access 2003.

I'm working on a form with combo boxes whose content must be filtered
depending on other values on the form. Working with a SQL server.
I've been told to change the .rowsource property programmaticaly (VBA)
building a new select with the WHERE based on the form filtering value; it
did work perfectly.

Unfortunatelly as I need a Datasheet or Continuos Form view, when updating
the .rowsource property, all the columns are changing. I've been told this
is by design.

I've read about trying to superimpose a text box in front of the combo box.
I did setting the "control source" property to get the value from the hidden
combo box. Even using these technique, all the columns are changing.

Help!!!!!

 

[Marshall Barton]

Access 2003.

I'm working on a form with combo boxes whose content must be filtered
depending on other values on the form. Working with a SQL server.
I've been told to change the .rowsource property programmaticaly (VBA)
building a new select with the WHERE based on the form filtering value; it
did work perfectly.

Unfortunatelly as I need a Datasheet or Continuos Form view, when updating
the .rowsource property, all the columns are changing. I've been told this
is by design.

I've read about trying to superimpose a text box in front of the combo box.
I did setting the "control source" property to get the value from the hidden
combo box. Even using these technique, all the columns are changing.

It sounds like the text box's ControlSource is set to an
expression (e.g. =thecombobox). Instead, the text box's
ControlSource needs to be set to the same field as the combo
box's ControlSource.

 

[Atlas]

It sounds like the text box's ControlSource is set to an

expression (e.g. =thecombobox). Instead, the text box's
ControlSource needs to be set to the same field as the combo
box's ControlSource.

Marshall, this is what MVP's are for!!!!
Yes you're right, now it works!

Thanks very much.