Form/Query Display Results Question

[AcmeGearSteve]

Hey there, quick question about Access 2007.

First off, I'm basically self-teaching myself Access 2007 for my job, so I apologize in advance if this question is dumb, or I don't understand a reply.

Basically, I have a form called "Find Part Form", and a query set up to look under my "Customer" Table that has a "Part Number" column-- everything goes fine and the button works.



The issue I'm having is that in my box, where I have the part number I want to look up, when I find it and click the "Find Results" button I made (that launches the query) it opens the query with ALL the part numbers and not just the ones I'm searching for. Is there any way to just display the Part Number w/ the "Customer", "Part Number", "Quantity" and "Location"? (I can figure out how to add the fields, the bigger issue is the only displaying results I need).

Thanks in advance,
AcmeGearSteve

[pbaldy]

I would likely use this technique to open a form:

BaldyWeb wherecondition

If you want to open a query, which most of us don't let users access directly, you'll need to add a criteria to the query that looks to the form where you entered the number.

[AcmeGearSteve]

I would likely use this technique to open a form:

BaldyWeb wherecondition

If you want to open a query, which most of us don't let users access directly, you'll need to add a criteria to the query that looks to the form where you entered the number.

Wow, I think this is exactly what I want!

I guess I don't want the query to be viewed, I had it set to Read Only so it wouldn't've been that big of a deal, but I think what you posted is exactly what I needed.

Now, my bigger question, with the coding in that link, can I just right-click and drop that in the SQL view or do I have to do it in VBA? Like I said, I'm pretty new to this-- I can dissect the code and figure out what values to change, I'm just not sure where to put it.

Thanks!

[pbaldy]

The code in my link is VBA code. It would go here if you've never used VBA:

http://www.baldyweb.com/FirstVBA.htm

You can also use a macro.

[AcmeGearSteve]

The code in my link is VBA code. It would go here if you've never used VBA:

http://www.baldyweb.com/FirstVBA.htm

You can also use a macro.

Thanks again, I'm just going to read through your whole tutorial listings and work from there; seems like the stuff I need.

[pbaldy]

I hope it helps; I've tried to include a lot of common problems there. Post back if you get stuck.