B
Bob
This is the first time I have seen this. I have a popup form that uses a
table to populate a combo box that the user selects the criteria for the
search. Then I have a query that references that combo box using
[Forms]![Form Name].[combo box name]. Once you select the criteria and click
on an OK button I created the macro and query then open the final form.
Now this works just fine until I send the file to someone else. I have sent
this database via email prior to the changes above and it worked, and even
now the only thing that does not work is the proceedure mentioned above.
I have even placed it on a server share where I can use it fine, but it
still fails for them.
You don't see the error until you close the db, but it is the same sort of
thing you would expect to see if you had the form name or the field name
incorrect.
I have not set any security on this file so all machines are using the
default MDB file.
table to populate a combo box that the user selects the criteria for the
search. Then I have a query that references that combo box using
[Forms]![Form Name].[combo box name]. Once you select the criteria and click
on an OK button I created the macro and query then open the final form.
Now this works just fine until I send the file to someone else. I have sent
this database via email prior to the changes above and it worked, and even
now the only thing that does not work is the proceedure mentioned above.
I have even placed it on a server share where I can use it fine, but it
still fails for them.
You don't see the error until you close the db, but it is the same sort of
thing you would expect to see if you had the form name or the field name
incorrect.
I have not set any security on this file so all machines are using the
default MDB file.