Refresh datasheet form with all records

I have a form that has a datasheet subform.  The datasheet subform by default opens with just 10 records displaying.  It's record source is a top 10 query.  But on the main form I have a command button which when clicked I want the sub-form to display ALL the records in the table.

What would the onclick event of the command button be?

--Steve
SteveL13Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
create another query with all the records. "qryALL"

in the click event of the button

me.subformcontrolname.form.recordsource="qryALL"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.