use SQL View in a form

[Jamie Ewart]

Hi

Is there a way to create a form in access based on the data from an sql
view?

Thanks

Jamie

 

[Steve Jorgensen]

If you are in an ADP, you can simply use the view name as the form's
recordsource. If you are in an MDB, you simply create a link to the view in
the same way you would link to a table, then use the link name as the form's
recordsource.