Populate Existing form from Query ?

[rshaw63]

Good Day everyone,



Is it possible to populate an existing form from a query in a database. A little explanation I have a database with 2 linked tables that stores different information. I want to be able to create a query based on Date or lets say Project Name and have the query results populate that form for printing or later view.
would I have to recreate the form as a copy or can it use the original form and populate the data in that form?

thanks in advance for your time

[mike60smart]

Hi

Your Form can be based on either the Table or a Query based on the table.

[mike60smart]

Hi
Can you upload a zipped copy of the database so we can see the structure of your tables?

[rshaw63]

Hi
Can you upload a zipped copy of the database so we can see the structure of your tables?

the file is 1.39 gigs just the structure alone is there another way?

[rshaw63]

I think maybe a better question would be how do i link that form in a query to populate matching information from the tables? That brings up another good question since my form stores so much information i had to break it up into 2 tables so i think i would have to have both tables tied to the query to repopulate that form that is created correct?

[rshaw63]

I have a query that finds the information i want however i need it to populate this form


left the query that locates information i want

Existing form i want to repopulate using above query results

[Welshgasman]

Set the form recordsource to your query

[rshaw63]

Thank you Mike So Much I figured it out it works exactly like i want it to now.

I modified the query to include all fields from both tables on that form, created a copy of the original form and pointed the datasource to that new copy and removed edit, add, delete permissions for that form.

[rshaw63]

thank you that did it !!! Have a great Day

[Welshgasman]

I would have used the one form?
If you need to add/remove a control etc, now you have to do it in two places?

[mike60smart]

Hi

I think you have a problem with the structure of your Form

This section looks wrong.

It looks like you are typing in the values

Are these fields in your Main Form table?

They should I believe be fields in a related Table.