Filter By Form on a Linked Table

[dubmunkey]

Hi all,

ive set up an access db which is linked to another access db- i need to be able to filter by form on the table linked to the othera ccess db- it allows me to on the original but not on the linked table giving me:

is null
is not null

as the options-

is this possible?

if so what is going wrong?

cheers

dubs

 

[Beady]

Hi,

I don't know if you figured it out yet, but I had exactly the same problem. Its nothing to do with linked tables (I thought it was as well).

There is a reply from ScotGem on another thread that solved it:

"Set the Filter Lookup property to Always. you can find it on the Data tab for each control.

Also this is a Forms issue, not a tables issue"


Regards,
Bernard D