M
mf_sina
HI!
I do have a question which i don't know it is about a query or form in
access.
i have a table (TblCustomers) with 5 fields: (ID,name,City,State,Country)
and a form (frmcustomers).i have another form (FrmSearch) which i placed 5
checkboxes on it to enable user select which fields he/she needs to see as
result.checkboxes are as follows:
(ChcID,ChkName,ChkCity,ChkState,ChkCountry)
searchQuery should work based on any selection the user has made. for
example i only need fields Name and city. so on my form i check city and
name checkboxes. leaving ID,state and country checkboxes unchecked.
also i need to output query based on user selection to a report.
what should i do?
I do have a question which i don't know it is about a query or form in
access.
i have a table (TblCustomers) with 5 fields: (ID,name,City,State,Country)
and a form (frmcustomers).i have another form (FrmSearch) which i placed 5
checkboxes on it to enable user select which fields he/she needs to see as
result.checkboxes are as follows:
(ChcID,ChkName,ChkCity,ChkState,ChkCountry)
searchQuery should work based on any selection the user has made. for
example i only need fields Name and city. so on my form i check city and
name checkboxes. leaving ID,state and country checkboxes unchecked.
also i need to output query based on user selection to a report.
what should i do?