Juan,
Yes, you can make a form with two unbound textboxes, where the user can
enter the Cust Name and Part Number criteria. And then, in your query,
in place of your existing parameter prompt, you would put the equivalent
of this:
[Forms]![NameOfYourForm]![NameOfTheTextbox]

Signature
Steve Schapel, Microsoft Access MVP
> Hello,
> I created a query with two parameters. Example,
[quoted text clipped - 13 lines]
> thanks for any info provided.
> J.
Steve Schapel - 24 Apr 2008 22:59 GMT
... or in fact a combobox may be more applicable than a textbox.

Signature
Steve Schapel, Microsoft Access MVP
> Juan,
>
[quoted text clipped - 4 lines]
>
> [Forms]![NameOfYourForm]![NameOfTheTextbox]
Juan - 24 Apr 2008 23:37 GMT
Hello Steve,
thanks so much for the info. I tried the textbox way and it seems to be
working fine. I really appreciate it big time.
Thanks again,
J
> .... or in fact a combobox may be more applicable than a textbox.
>
[quoted text clipped - 6 lines]
> >
> > [Forms]![NameOfYourForm]![NameOfTheTextbox]
Derek - 24 Apr 2008 23:04 GMT
Hi
a nice touch would be to use two combo boxes instead of text boxes that
select their data from the tables that hold the customer and part number
values. this way your user wont have to type anything.
> Juan,
>
[quoted text clipped - 23 lines]
>> thanks for any info provided.
>> J.