Solved

Using a query to do a search

Posted on 2012-03-20
2
282 Views
Last Modified: 2012-03-20
When i run the query parameters pop up. Asking for the fields that I have in the search. Below is the code that I am using.

Like "*" & [Forms]![Inventory Report]![Employee Name] & "*"

I have one table that the query is getting the information from.
Database1.accdb
0
Comment
Question by:gigifarrow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 42

Accepted Solution

by:
dqmq earned 250 total points
ID: 37744418
The query wants field from the form.  If the form is open, then it will take the form instead of prompting for them.  You cannot do that with a modal form.  Change the form's modal property to No.
0
 

Author Comment

by:gigifarrow
ID: 37744451
Thank you for your help. That was the problem alright!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question