Search Form - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Search Form

Amina Jones

4 years ago

I created a pymt search form using the customer firstname and lastname. The issue I am having is when I put in any of the customers names it brings up one customer which is "Lea Willis". Not sure why its not working. When I run it using the query design and I enter the parameters it brings up each individual customer. I have screen shots.

	Amina Jones OP @Reply 4 years ago

	Amina Jones OP @Reply 4 years ago

	Amina Jones OP @Reply 4 years ago

	Amina Jones OP @Reply 4 years ago

	Amina Jones OP @Reply 4 years ago

	Juan C Rivera @Reply 4 years ago
On your run query button what is the code? did you reset the boxes to = "" re-query after you update? also close the form and retry.

	Amina Jones OP @Reply 4 years ago
Run query i used the wizard. I did = it gave me the same results bringing up one customer no matter the name inputted

	Adam Schwanz @Reply 4 years ago
So when the form isn't open and you open the query and manually enter the names, it opens up more people? When the form is open, no matter who you put in you get Lea?

	Amina Jones OP @Reply 4 years ago
In the query it opens up the specific customer i entering the parameter and all of their payments

	Adam Schwanz @Reply 4 years ago
So it does work correctly if you just open the query up from the navigation pane without the form open? It only has problems when the form is open?

	Amina Jones OP @Reply 4 years ago
Yes

	Amina Jones OP @Reply 4 years ago
Well i just saw when I'm inside the query design it asks for the parameters but when i just click to open the query from the navigation pane it pulls up all the customers

	Kevin Robertson @Reply 4 years ago
Is the query closed each time you run it with the "Open Query" button? If not you may need to add a CloseWindow command to the Embedded Macro behind the button.

	Amina Jones OP @Reply 4 years ago
Yes It's closed

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View