Multiple Queries that updates the main table

[librag]

Need some help with the following:

1) I have multiple queries for my Master Table - the results are brought into a form.

Question 1 - How can I get 4 different query result to come into the same form? is this even possible or do I need to create 4 different forms for each respective queries?

Question 2 - Once the infomation comes into the form whcih is the query result that I have created, end user will be entering and updating information into the form, - how can this be updated to the Master Table? As it seems to me that query result doesnt cant be edited?

Thanks

Gini

 

[Jeanette Cunningham]

The question you posted is very general - you usually get a much better answer if you give more details about your form/ problem.
In general - a form has a record source. The record source can be a query or a table.
If you want to show the information from other related tables, use one subform for each related table.

If this doesn't help, post back with more details about what you are trying to do.

 

[librag]

I actually ended up using Filters instead of querying the info. Solved all the problem. Thank you though