I am creating SQL Server Forms using Access 2000 tools (this is a new feature). When I use a table as a record source to create the form, it does it fine. But when I use either Views or Stored Procedures, I cannot do it, especially when I use a JOIN in views and stored procedures.
Do you know any way of using join views and stored procedures as record source while building forms. Thanks