I am wondering if its possible to add a where condition to the record source of a form?
I have the table requests having an attribute named country. For that table i have a form showing all attributes of the table.
When logging in to the db I retrieve the user information out of the person table which also has an attribute named country.
So what I want to accomplish now is that based on the user's country I only want to display those records of the request table having the same country like the logged in user.
How can I accomplish that. Remark: I only use the record source property of a form to display the records. I do not have a view of the request table. And because a view will demand too many changes to my existing forms i don't want to user one.
So my thought was to add a where condition to the record source of the form. Is that possible? and how?
Thanks in advance
hmm. I guess I will need more help with that. Could you kindly try to exmplain your suggestion in a bit more detail. Thank you very much in advance.
Note: the record source of the request form looks like this. (in the properties form): record source = REQUEST
is it possible to do something like:
record source = REQUEST where request.country = thecountryiwant