Hi Is there a way to create a form in access based on the data from an sql view? Thanks Jamie
J Jamie Ewart May 19, 2004 #1 Hi Is there a way to create a form in access based on the data from an sql view? Thanks Jamie
S Steve Jorgensen May 19, 2004 #2 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.
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.
