Editing data from multiple queries

[MHernan1]

Hi all,



I can't seem to figure out how to edit data from multiple queries.

Here is the scenario:

I have a form that has a field that is used by another query. So for example: I enter a phone number into Form A, Query A is run based on that phone number and I see the results in Query Result Form.
Now when i go into that form that displays the query results, I can edit the record no problem.

I have a different form that is set up the same way except there are multiple fields that tie to multiple queries and the corresponding form to view the results. So Form B has let say 3 fields for 3 separate phone numbers, that are feeding 3 separate queries (all querying the same table) and I can see the returned results on a separate Query Results Form.

But now I can't edit any of the fields on the Query Results Form for the multiple queries.

I tried testing just a single query using the same scenario as the first one, and I can edit it fine, its just when i have multiple queries.

The only thing I can think of is that is won't let me edit multiple fields on multiple records in the same table simultaneously, but that's just me guessing.

Thank you in advance for any help you can provide.

[JoeM]

Take a look here: http://allenbrowne.com/ser-61.html

[MHernan1]

Thanks JoeM, I have gone through the whole list however and nothing seems to change. I can run each query individually and edit it fine, but when I run query based on those 2 individual queries, I can't edit the results.

Very frustrating as this is basically the last functionality that I need to work through before going full speed on the rest of the database.

Any other suggestions?



UPDATE: I figured it out, of trying to combine multiple queries, I used the "or" function to pull the data from a single query! Thanks for all the help!