Question Locked

Using Access Form Fields as "contains" criteria for a query

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

This discussion is closed to new replies.