This question has been asked a lot..
When you read want to run a searchable query and then
copy that into a form so that you can update your table
you'll run into the above error.
The solution is simple, but probably overlooked from the
posts I have read.
in the Select Query properties
change Run Permissions to Owner's
I also take the SQL code from the Query and paste that in
to the Form Property's Record Source field , but you could
probably just use the query itself ...
This will solve that most annoying problem.. was taking me
all day to do it . .
-- David
When you read want to run a searchable query and then
copy that into a form so that you can update your table
you'll run into the above error.
The solution is simple, but probably overlooked from the
posts I have read.
in the Select Query properties
change Run Permissions to Owner's
I also take the SQL code from the Query and paste that in
to the Form Property's Record Source field , but you could
probably just use the query itself ...
This will solve that most annoying problem.. was taking me
all day to do it . .
-- David