Search Box form in Navigation Form

[Breanna]

Hello,

I am very new to Microsoft Access and have been asked by the company I work for to create a database that integrates inventory and employee information. (like what we have on location, who has what checked out etc.) I have all my data tables set up and have used a video to create a search form.

I also have created a navigation form where I can easily view all the info I need. I have added the search form to the navigation form. My search form has a text box for 'Item' and 'Assigned number' then a button for run query. I want to be able to enter in the search criteria I need then click the button and have it bring up that specific info. When I enter in a search criteria another box pops up saying "enter parameter value" then below that is says "Forms!SearchFI!AssignedNum" then I can enter in the info and click ok or just leave it blank and click ok. then it brings up the same thing except for item. after that it will load the quary with the info I need. I hope that makes sence

Why is it not just opening the query after I click the run query button? I do not want it to bring up that additional box in order to search.

for my search form under criteria in design view I have this Like "*" & [Forms]![SearchFI]![Item] & "*"
I need help and I am not good at this.

 

[smig]

Make sure your search form's name is SearchFI and the text box' name is AssignedNum
You will get this parameter box if the names are wrong or if you close the Search form before running the query.

 

[Breanna]

Thank you. I did have them named wrong so now that I have fixed it they are functioning correctly so when I have the search form open I can enter in my parameters, click run query and it opens the query with the info I need.

What I would like to do is add the search form as a tab in a navigation form I already have set up and be able to use it from the navigation form. When doing it this way the same 'enter parameter' box pops up. Is this even possible? If so where would I go to get it set up so it functions without the parameter box popping up?

 

[essaytee]

Thank you. I did have them named wrong so now that I have fixed it they are functioning correctly so when I have the search form open I can enter in my parameters, click run query and it opens the query with the info I need.

What I would like to do is add the search form as a tab in a navigation form I already have set up and be able to use it from the navigation form. When doing it this way the same 'enter parameter' box pops up. Is this even possible? If so where would I go to get it set up so it functions without the parameter box popping up?

If I understand you correctly, you have now moved the search criteria form to another form. What you need to do is alter your query to now account for the new form. That is, you will need to change the parameters in the query to reflect the new form.

What is happening now is that from your new form, you run the query. As the old search form is not open (assuming it's not open) the input boxes appear in order to gather the criteria, then the query runs.

As Smig said, make sure the form and control names are spelt correctly.

 

[Breanna]

If I understand you correctly, you have now moved the search criteria form to another form. What you need to do is alter your query to now account for the new form. That is, you will need to change the parameters in the query to reflect the new form.

What is happening now is that from your new form, you run the query. As the old search form is not open (assuming it's not open) the input boxes appear in order to gather the criteria, then the query runs.

As Smig said, make sure the form and control names are spelt correctly.

You are understanding correctly. You make this sound obvious thank you. I am off work now but will try and fix that tomorrow. Under the criteria for the query do I have to add the new form name before the old one since there are now two or do I just change the name completely? I will try both tomorrow.

 

[essaytee]

You are understanding correctly. You make this sound obvious thank you. I am off work now but will try and fix that tomorrow. Under the criteria for the query do I have to add the new form name before the old one since there are now two or do I just change the name completely? I will try both tomorrow.

Change the name completely. If you still want the old query, keep it, create a copy of it, and change the form/control names completely.

 

[essaytee]

When you refer to a 'Navigation Form' I took that as a form that you created. Is that correct?

 

[Breanna]

When you refer to a 'Navigation Form' I took that as a form that you created. Is that correct?

I did not create the form itself. In access under create there is an option that says Navigation. When you click on that it brings down layout options. I chose one of those and have different reports (based on set up query's) for each of the tabs. To me it looks like a website page. So after I created the search form and the query associated with that I moved them to the tabs on the navigation form. I am going to change the names in criteria now to see if that makes them functional in the navigation form instead of as stand alone parts. If that makes sense. (I hope)

 

[Breanna]

Change the name completely. If you still want the old query, keep it, create a copy of it, and change the form/control names completely.

I changed the criteria from
Like "*" & [Forms]![SearchF]![Item] & "*"
to
Like "*" & [Forms]![Main Page]![Item] & "*"

SearchF was the original search form that I moved onto the navigation form (named Main Page) Doing this I can go to the search tab, type in my search and click run query. The enter parameter box does not show up but it no longer filters the search. It shows me everything (not just what I searched for)

I feel like I am missing something. Is there something else I should be entering into the criteria?