Very Computer

I have a form (generated ADO code using the Wizard) to work with a table
in ACCESS.

I needed to add another table (for lookup reference) to this form, since
I didn't want to mess with the generated code/set procedures, I added a
ADO control.  This is where it becomes difficult.  The control is to
look out to another table and retrieve the "codes" the user is allowed
based on the category the user selects.

In example:
There are two combo boxes, in the first combo box are the hard coded
CATEGORIES that the user selects from.  After selecting one of the
Categories the user then goes to the second combo box and selects the
CODE from the list of available Codes in the Category.

This is the problem:
The SQL to retrieve the "Codes" is dependant on the String value that
contains the Category.  The SQL code is typed into the Property Page,
obtained by clicking the Row Source Item of the ADODC, does not deal
with quotes hence, can not obtain a string value.  The Row Source is
needed to tell the ADODC where to obtain it's information from.

If I haven't made this too vague or complex, any help is greatly
appreciated

Mike

If you are trying to set the recordsource of the ADODC control in code -
this is how I did it -

strSQL = "Select [code] from [tbl] where category = " & cboCategory

With adodc
    .CommandType = adCmdText
    .RecordSource = strSQL
    .Refresh
End With

Mike