Apply Filter Macro

[Peter La Mont]

Hi,

I am trying to create an Apply Filter Macro that uses an Unbound Text Box
located in a Form Header to filter the Form Detail. I can only get it to
work by typing in the full form info and I would like it to be Active Form
friendly so I can reuse this macro again.

Example
Where Condition: [File#] Like [Forms]![PriceForm]![FileLookup]

File# is a 10 character Fixed Length string.

Any help would be GREATLY appreciated!

Thanks
Peter La Mont

 

[Douglas J. Steele]

Sorry, it can't be done.

You can only refer to controls on forms (or reports) in the manner in which
you've currently got it.

 

[Peter La Mont]

Wow really? Even though I can do it on the "SetValue" function? Its a
limitation of the filter?

Sorry, it can't be done.

You can only refer to controls on forms (or reports) in the manner in which
you've currently got it.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi,

I am trying to create an Apply Filter Macro that uses an Unbound Text Box
located in a Form Header to filter the Form Detail. I can only get it to
work by typing in the full form info and I would like it to be Active Form
friendly so I can reuse this macro again.

Example
Where Condition: [File#] Like [Forms]![PriceForm]![FileLookup]

File# is a 10 character Fixed Length string.

Any help would be GREATLY appreciated!

Thanks
Peter La Mont