Apply Filter Macro

P

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
 
D

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.
 
P

Peter La Mont

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

Douglas J. Steele said:
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)


Peter La Mont said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top