Answered
Creating secondary recordset from primary recordset
Having created the first simple recordset (recordlookup)
based on a search text box and displaying it in a dynamic table
(only selected columns), I then embedded a post form with a submit
in the table.
How do I then create a secondary recordset "recorddetail", based on a single selected row from "recordlookup"?
I attach some code I have tried, but it always returns the recordset, with the variable set at "1", rather than using the ID that I wanted.
Am I getting my syntax right for the variable or do I have to look at this another way?
How do I then create a secondary recordset "recorddetail", based on a single selected row from "recordlookup"?
I attach some code I have tried, but it always returns the recordset, with the variable set at "1", rather than using the ID that I wanted.
Am I getting my syntax right for the variable or do I have to look at this another way?
AdChoices