J
Jim Scarlett
Sorry to bother you but I'm at my wits end! I have 3 combo boxes on a form.
Each gets its data from a different SQL stored proc showing multiple columns.
users select from any *1* of them (not in combination). I extract the value
of the required column - assign it to a parameter for the required SQL proc
and then want the sub form to call the query using said Parameter (or get the
subform to display the records somehow! In debug the param is correctly
assigned but I can't get the sub form to display the resulting recordset.
Been thru Northwind til I'm blue in the face but can't get it. Hope someone
can help an ignoramus.
Each gets its data from a different SQL stored proc showing multiple columns.
users select from any *1* of them (not in combination). I extract the value
of the required column - assign it to a parameter for the required SQL proc
and then want the sub form to call the query using said Parameter (or get the
subform to display the records somehow! In debug the param is correctly
assigned but I can't get the sub form to display the resulting recordset.
Been thru Northwind til I'm blue in the face but can't get it. Hope someone
can help an ignoramus.