I have been using a query for over a year now to send a form to users to update the data in the fields. It has worked well baring a couple of issues here and there. However, this time I am having a difficult time figuring out what the issue is. I can see what is happening, but I don't know why.
Before the issue I would send email forms to people using create email from the External Data tab. It would ask me a series of related questions and I would answer them all. One of those questions is Do you want to want to update existing data or gather new data. I always select update existing data. The data for the most part has not changed at all in some time. However, the option to update data is no longer an option. When I click on the set Properties to control the automatic processing of replies link the option "Only allow updates to existing data" is greyed out. So the fields are blank when the users receive the form. The email address is in the query and I can create a new DB and the option is there, but for this db I cant see it. I have tried to recreate the query that filters the data, but still have the issue. From this database I have created a new query based on other data and it works as expected. Just this data is an issue.