Button on form to collect data via email.

[534dna]

Hi folks,

I have quite an annoying problem here. I have a form in my database and i have created a button to open the collect data via email wizard. I used a macro which selects the table and then opens the collect data via email wizard. The macro works fine when i open it from the navigation pane but it will not work from the button. When i click the button i get a "Query support unavailable." error message. Now this worked fine when I first implemented it but it does not seem to be working now. I would really appreciate it if anyone could help.

 

[534dna]

It seems that removing referential integrity from the table has solved the issue. I still do not understand why this only causes a problem when using a button. I would have thought that referential integrity on the tables relationship would not matter if you used a button for the macro or not.

Confusing.