Change predicate value Access query

[RandDUser]

I am trying to run a query that will return a set number of records. I have used the sql logic of SELECT TOP 500 which will return the top 500 values. However, I want the user to specify the number of records using an unbound textbox in a form.

I tried the following code:

SELECT TOP [Forms]![Form1]![TextBox1] Table1.Field1 ...

However, it will not except the code, any suggestions?

Thanks.

 

[Golom]

You usually need to build the SQL as a text string and then run it when you want do anything more elaborate than change WHERE, HAVING or ORDER BY clauses.