Display

[JobWK]

I want to create a Form using 3 tables that are related. My form will not display in "Form" or "Layout View".

I am using the Form Wizard.

 

[ghudson]

Create a query to join your tables and the fields you want in the form. Then set the forms record source to your query. I normally use the SQL as my forms record source instead of creating queries but do what you are comfortable with.

 

[boblarson]

Also, many times you may not be able to have 3 tables in your form's recordset. It all depends on the relationships that each has. If they are one-to-many-to-many, then I don't think it will work. Also, for a one-to-many relationship, normally you would use a main form for the one and a subform for the many side.

 

[JobWK]

Thank you I will try that and let you know.