I have a Access 97 MDB that has a form and continuous subform on it. When I tried to convert it over to an ADP and MSSQL 2000 I can select an item for the first row of the subform but when I enter one for the second row I get an error.
I thought that I had this solved at one time by getting my ReSynk and UniqueTable settings right, but that did not solve my problems.
What I think is happening is this:
My subform has 2 entry fields and 3 "display" fields. When I select something (part number)from a combobox in the first data entry field I should see the related info in the "display" fields (color, weight, qty) Like with a Dlookup, but you can't use a Dlookup on a continuous subform which is why this query is kind of strange to me. The 2 entry fields are stored in a table and the 3 "display" fields come from existing data in other tables.
The subform is bound to a query, that when you enter the part number and do a Refresh it returns the other data, exactly what I want. But I need it to work in the .ADP and that is where I think my problem is: How do I get an SQL query to work on a continuous subform so that I can enter my part number and have its related data display AND enter additional records?
I hope that I made myself clear, if not I apologize.
I thought that I had this solved at one time by getting my ReSynk and UniqueTable settings right, but that did not solve my problems.
What I think is happening is this:
My subform has 2 entry fields and 3 "display" fields. When I select something (part number)from a combobox in the first data entry field I should see the related info in the "display" fields (color, weight, qty) Like with a Dlookup, but you can't use a Dlookup on a continuous subform which is why this query is kind of strange to me. The 2 entry fields are stored in a table and the 3 "display" fields come from existing data in other tables.
The subform is bound to a query, that when you enter the part number and do a Refresh it returns the other data, exactly what I want. But I need it to work in the .ADP and that is where I think my problem is: How do I get an SQL query to work on a continuous subform so that I can enter my part number and have its related data display AND enter additional records?
I hope that I made myself clear, if not I apologize.
