Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Filter Problem

Author  Topic 

funkkube
Starting Member

8 Posts

Posted - 2004-09-30 : 14:42:30
hi
I want to apply a filter in a macro when

The value of the Repname = the value of the combo box (lookup from another table)

How do i specify the value of the SAVED combo box value? its called Combo16?
I keep getting a pop up window asking for a value..
thanks

clarkbaker1964
Constraint Violating Yak Guru

428 Posts

Posted - 2004-09-30 : 17:59:32
Select * from MyTable
WHERE
Field=[Forms]![Ftvs_Param-00]![FVERSION]

What ever is selected in that box will be the filter for that field.

Go to Top of Page

funkkube
Starting Member

8 Posts

Posted - 2004-10-01 : 06:03:40
Hi
Thanks for the reply..
I am a bit of a newbie..
In the Macro I am using APPLYFILTER so i have to fill in

Filter Name
Where

sections.
Where does ur suggestion go?
thanks
Go to Top of Page
   

- Advertisement -