Query para base on combobox value

mderby

Registered User.
Local time
Today, 22:55
Joined
Apr 14, 2003
Messages
41
Dear all,

I got one table tblProject with this field:
Project
ProjectID Key Field
Pro Name
Owner

got a form (frm1) with subform (frmsf1). The subform based on a query.

qry1 is based on tblProject with this all the fields in it. There are one criteria for field Owner:
([tblProject].[Owner])=[Forms]![frm1]!cboOwner.column(2))

on frm1 got a combobox cboOwner with this sql statement
SELECT tblProject.[Project ID], tblProject.[Pro Name], tblProject[Owner]
FROM tblProject
WHERE (((tblProject.[Project Name])="Daily"));
user can only see value from the field Owner cause the rest is hidden.
then upon selecting a value , i put some code in it to
requery the subform.

but this is not working because upon loading frm1 there will be error asking for Forms!frm1!cboOwner.column(2) parameter values

Please helpppppp !!!!!

mderby
 

Users who are viewing this thread

Back
Top Bottom