Maybe this is the problem?
The search button on the NAICS code form just opens the query. How can I be sure that the query is taking the selection from the combo box?
Code for NAICS query
SQL for Query:
SELECT Profiles.[Company Name], Profiles.[Company Contact Name], Profiles.[In what state is the firm incorporated?], Profiles.[List and describe each major product/service offered by your fir], Profiles.[List and describe each major product/service offered...
I Love You
You dont understand how HAPPY I am!! Thank you so much...
but one more problem:
The Keyword search is working thanks to your help, but the NAICS code isnt - the difference for the NAICS code on is that I am using a combo box which is sourced from a table in the database. The search...
So far
For the "criteria" in the "Primary NAICS Code Query" - I have:
Like [Forms]![Primary NAICS Code Search]![NAICSlist] & "*"
For the criteria in the "Product or Service Keyword" Query - I have:
Like [Forms]![Keyword_search]![WhatKeyword] & "*"
and for the "or" criteria I have:
Like...
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...