How do I populate a form using query result?

[bbmak]

I have created a search query that allow users to search existed record in database.


The query work completely fine, and it gives me the data that I want when I fill in my criteria. However, the query result is not showed in a form, but show in a query window.

The form is like that
Company (drop down with a list of company)
Employee (drop down with a list of employee)
Program (drop down with a list of program)
Others (some other fields)
...
Go Query (a button)

How do I pass the query result into a form that I made? So the users can edit and update the record.

[June7]

Reference the query in the form RecordSource.

Review: http://www.datapigtechnologies.com/f...tomfilter.html

[bbmak]

I watched the video, but I still confuse on how to link my search form and populated form together.
anything to do in the "Go Query Button" to link them?
Sorry, I am a newbie on Access.

[June7]

One form can be used for search and display.

Is your query a dynamic parameterized (criteria references form controls for input)?

Set the RecordSource of the 'search' form to the query.

Create textboxes on the search form and bind them to fields.

Instead of code to open query, have code to requery the form.

The video demonstrates the above.

Or create a report that uses the query as RecordSource. Then code would open the report instead query.

[bbmak]

Thank I got it.
Is that also apply to a subform as well? I can pass the strings into a subform?

[June7]

Yes, a subform is just a form. Actually, it is a subform/subreport container control that holds an object. That object can be a table, query, form, report.

[bbmak]

thank you so much