Forms with no record source

[Guest_imported]

Hello All,

I want to have a form that isn't bound to a record source. I want to execute a SQL Query to SQLServer where I expect to return more than 1 row. I want to then display this data in on the form and allow the user to see at leas the first 5 records on the form before having to scroll to see the rest. I have only been able to get one record to display. Any help on this would be appreciated.

David

 

[Psychpt]

i'm not quite sure what you're trying to do but you can make the sql statement the recordsource on open of the form.

 

[braindead2]

do you have the form default view in single form
if so try data sheet or continious forms