Prev: Is there a native access version of the treeview?
Next: Auto Populate
From: samotek via AccessMonster.com on 10 Apr 2010 02:48
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/Forums.aspx/access-forms/201004/1

From: Jeanette Cunningham on 10 Apr 2010 05:25
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(a)uwe> wrote in message
news:a64f40cdd3e99(a)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/Forums.aspx/access-forms/201004/1
>


 | 
Pages: 1
Prev: Is there a native access version of the treeview?
Next: Auto Populate