Access 2010 - Pulling the TOP/max number of records user prompted for value

[Kennedy731]

I would like a user to specify the total number of records they need from a query result. The result must be random, therefore cannot filter on any field or data in the table.
On a form, the user enters the total # of records they need and selects a button that executes this:



DoCmd.RunSQL.SELECT DcountRDP.RDP_IND, DcountRDP.GRP_ST_CD, DcountRDP.AUDIT_STATUS, DcountRDP.AUDIT_TYPE, DcountRDP.AUD_ID, DcountRDP.ACURT_IND, DcountRDP.AUD_DT
FROM DcountRDP
WHERE DcountRDP.MaxRecords = [Forms]![Open_Frm]![IL]

This is not working at all.

How can I make it possible for the user to enter a total needed or be prompted to enter a total and then randomly produce the first top # of records that they specify?

[June7]

Doesn't work partly because can't 'run' a SELECT query, only action queries (UPDATE, INSERT, DELETE, etc).

SELECT queries in VBA are to open a recordset. Open a recordset to programmatically manipulate data.

What do you want to do with the data?