Amend Top Value via Text Or Combo Box

[CarolW]

Is there a way whereby I, or another user, can amend the ‘TOP’ value of a query via a Combo or Text box entry on a form? I have searched this Forum for a solution to this very problem but have had no success. I understand how to achieve this via the queries ‘SQL’ view but cant figure out a way to do it by the way that I have already described!!

Your advice or a ‘pointer’ in the right direction would be extremely well received.

Thanks for your time.

Have a nice day...

Kind Regards

CarolW

 

[Moniker]

Search on Dynamic SQL. For my specific example, look at the result where Eugeneus was the original poster. I specifically point out how to write dynamic SQL in there.

 

[CarolW]

Amend Top Values - Dynamic SQL

Search on Dynamic SQL. For my specific example, look at the result where Eugeneus was the original poster. I specifically point out how to write dynamic SQL in there.

Moniker,
Once again many thanks for your prompt response and pointer in the right direction. Have not had a good chance to experiment in the area of dynamic SQL but i'll give it a go very shortly. Apologies for not responding sooner...

Thanks

CarolW