Access Datasheet subform not working for SQL Recordset

[Guest]

I have a msaccess form which was developed based on SQL server tables with a
main form and related subforms. The subforms are also independent forms
created based on queries on sub tables

I modified the master form to accomodate sql server changes by
opening a connection to sql server

Assigning a query to a recordset for the main form
and individually assigning the textbox values to the results of the recordset

Now with the subform I am trying to do the same but as it is in datasheet
view and if the query fetches 20 records its showing all the 20 records same
ie, the output of the first row. How do I make access behave the same way
with sql server recordset ?

I have assigned the recordset as recordsource for the subform but it dosent
work...

Thanks
Madhuri

 

[Guest]

Oh I am sorry, Please correct the first line as form developed based on ms
access tables.