E
Ernie
I am new to Access ADP using a SQL database and have a question about a
limiting records in a combo box based on a subform based on a value in a text
box on the main form. The methods I used in MDB jet databases don't seen to
work here. This is the SQL from the drop down list:
SELECT tbluserID, internalnumber
FROM tbluser
WHERE (tblcustomerID = forms.[view ro]. tblcustomerID)
I get the error message "The column prefix 'forms.view ro' does not match
with a table name or alias name used in the query".
I would greatly appreciate any help on this.
If anyone could recomend a good source of training (online or book) for
Access ADP and SQL database I woud also be greatful. Thanks.
limiting records in a combo box based on a subform based on a value in a text
box on the main form. The methods I used in MDB jet databases don't seen to
work here. This is the SQL from the drop down list:
SELECT tbluserID, internalnumber
FROM tbluser
WHERE (tblcustomerID = forms.[view ro]. tblcustomerID)
I get the error message "The column prefix 'forms.view ro' does not match
with a table name or alias name used in the query".
I would greatly appreciate any help on this.
If anyone could recomend a good source of training (online or book) for
Access ADP and SQL database I woud also be greatful. Thanks.