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

  • Thread starter Thread starter Atlas
  • Start date Start date
A

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!!!!!
 
Atlas said:
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.
Click to expand...

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.
 
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.
Click to expand...

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

Thanks very much.
 
Back
Top