Changing a form using direct table to a query

[Kemidan2014]

I am working to help another department with an access database that was set up to document support calls from that department to others

I noticed that thier form's is using the main table of data as its record source instead of using a query to bring up records. so everytime they open the form they have access to over 3000 records either Open or Closed when honestly they only need to see the Open records. Creating the query is easy enough

but can i change the form to utilize the new query instead of the table itself? if so how does one do that? Or am i looking have having to remake the form in its entirety?

 

[welshgasman]

You just change the source of the form from the table to the query.
Make sure all field names remain the same.

 

[Kemidan2014]

I know it must be some where im not clicking or seeing, i see "Control source" and "Row source" but i am not seeing Record source as a property, as I click around in Design view.

 

[welshgasman]

Put the form in design mode.
Click the small box top left that is at the junction of the rulers.
Select the data tab in properties and the dropdown for the recordsource property for the form. Choose your query from there.