Hi,
I have a simple question about record sources for forms. I have a main customer form with a services performed subform. The services performed subform has a one to many relationship with customer number(in tables). I also have three buttons which bring up pop up forms. All the popup forms have a one to one relationship (in tables) with customer number on the main form. Ideally in this situation should I have all these various forms sourced off one query, or should every form have it's own query? What record source is best for filtering the information between forms yet allowing the user to still enter information into the tables? Will sourcing all these forms off one query be inefficient? Thanks in advance for any help and insight!
Scott

As a standard practice, it is better to use a query as the recordsource for a form or report rather than the underlying table. You will have an easier time implementing security and making modifications.

You will need to use a separate query for each form that you will have open at the same time (assuming you will be doing any updating) otherwise you will run into the dreaded "record locked by another user" error.