Combo Box Rowsource property

[Shetty]

Deer Friends

I want to set Rowsource property of combo box while using command button in
my form

By default rowsource of combo is based on querry
I want to modify this querry providing modifying criteria given for one of
the field

Actually I want to filter the values in the row source of the combo box

Please advise

ramesh shetty

 

[Allen Browne]

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

I guess some of us do like venison.

 

[Tom van Stiphout]

On Wed, 6 Feb 2008 17:39:44 +0530, "Shetty" <[email protected]>
wrote:

(I'm not a deer but will try to answer anyway
Perhaps you could have two queries, and you would decide which one to
use in the command button's click event. Pseudo-code:
sub command1_click()
if some conditions are true
my_combobox.RowSource = "query1"
else
my_combobox.RowSource = "query2"
end if

-Tom.