I am an intermediate user of Access and I am having difficulty using some forms that I have created that I am using separately as criteria for their respective queries.
Two forms are currently set-up and these are the problems:
1. Form name: Primary NAICS Code Search
This form contains one field called “NAICSlist” (record source is from a separate table entitled “NAICS codes”)
“NAICSlist” is the name of the combo box for the field.
I would like to use the selection in that form as criteria in my query called “Primary NAICS Code Query” – its not working
2. Form name: Keyword_search
This form contains a text box called “WhatKeyword”
I would like to use whatever I enter in this text box as the criteria for the Query called “Product OR Service Keyword” – this is working generally BUT it is only bringing up results that START WITH whatever I enter in the text box – I want it to return query results that CONTAIN ANYWHERE IN THE FIELD what I entered
CAN YOU HELP???
Mia