Filter in the form

In my tabular form i have a field called supplierid.I want to build a button
on my form with the following alternatives:
1. show only the fields with supplierid = 1
2. show only the fields with supplierid = 2
3. show all

whixh is the best method to do it?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201004/1

If you use a combobox instead of a button, it will still work if you get
another supplierid.
The combo row source can be a query based on the supplierid table.
Use a union query to get the option for all.


Select tblSupplier.SupplierID, tblSupplier.SupplierName
From tblSupplier
Union Select Null As SupplierID, "All" As SupplierName
Order By SupplierName

If you use the combo wizard to make the combo, choose the option to find a
record.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"samotek via AccessMonster.com" u15330@uwe wrote in message
news:a64f40cdd3e99@uwe...
In my tabular form i have a field called supplierid.I want to build a
button
on my form with the following alternatives:
1. show only the fields with supplierid = 1
2. show only the fields with supplierid = 2
3. show all

whixh is the best method to do it?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201004/1