Can Filter Lookup work with only Runtime?

[Owl]

I have an Access 2007 database which will be on my users' computers on Runtime. They don't have Access on their computers.

I have a form where, on my own computer, I can set the field FeeCode to Filter Lookup and then I can right-click and use a filter on that field perfectly.

I am assuming that that will NOT be possible on their computers on Runtime. Am I correct about this?

Thank you for any help.

[June7]

Don't know, do you have a computer without Access you can test this on?

[ajetrumpet]

I am assuming that that will NOT be possible on their computers on Runtime. Am I correct about this?

that's probably completely related to the "right click menu" being turned on or off on Access forms. Pretty sure that, if you deploy an Access app to someone, that's shut off automatically. Obviously it has to be, otherwise they would have access to design changes which goes against the purpose of a deployment anyway. For non-secure access files though (non-executables, like MDB/ACCDB), right click menus on forms can be shut off via form properties and access options.

As an alternative, why not put a control on the form and use code to filter out data based on an input?