strSQL =selecting information from combo box

[cyndithomas via AccessMonster.com]

User will select preset information from a combo box which will provide the
correct data using a record source query.

 

[fredg]

User will select preset information from a combo box which will provide the
correct data using a record source query.

Is there a question here?

 

[Michel Walsh]

Unless the original poster is unaware that the ComboBox value will return
the selected value:


Me.ComboBoxName.Value


and if the combobox list has many columns, then



Me.ComboBoxName.Columns( index_0_based )

will return the specified column of the selected row.



Vanderghast, Access MVP

 

[cyndithomas via AccessMonster.com]

User will select preset information from a combo box which will provide the
correct data using a record source query.

Hello All:

thank you for replying to my questions...but the issue was resolved. Sorry
for the incomplete Question

 

[cyndithomas via AccessMonster.com]

Hello All:

thank you for replying to my questions...but the issue was resolved. Sorry
for the incomplete Question