Query open in form View

[RustyRick]

I have a form for data entry into my main table. Some records are correct, but some I need to come back to later and correct.

So I have a button on the form to run the Query which works fine. But it opens in a new "Data Sheet View".

Can I make it open in the original form so I can edit the queried data?

 

[missinglinq]

Assuming that the Form has Controls that are Bound to Fields that appear in the Query, simply set the Form's RecordSource to the Query.

Me.RecordSource = "QueryName"

Linq ;0)>

 

[RustyRick]

I must be missing something, or I don't explain things complete.

I put your code in the Record Source field in Properties.

And open the form the Query has run showing 22 records.

However I don't want the Query to run until I push the button?

Wha have I got wrong?

 

[RustyRick]

I maybe should have added that each field in the forms is directly related to each field in the table. Hence I assume they are all "Bound" controls.