How do I BRING UP AND DISPLAY PRICING or customer info . . .?

  • Thread starter Thread starter flowerman
  • Start date Start date
F

flowerman

I have forms, queries, and reports to sort, count and organize my data
by dates etc . . . but what do I need to do to get Access to show me
the price of an item (stored in a table) when I enter the items
description on my screen? For instance, if I enter product type, size
and color . . .I want a specific price to appear in a box. How do I
make this happen? Would this take place on a "form" or some other type
of "sheet"? I don't want to have to open a report to see it, I'm
hoping to get it to show up on the screen I'm working on and such that
if I change one of the description fields, the price would change
accordingly. It's like in DOS when you type in a customer name and
all of their pertinent info shows up on the screen.
Thank you,
Flowerman
 
I have forms, queries, and reports to sort, count and organize my data
by dates etc . . . but what do I need to do to get Access to show me
the price of an item (stored in a table) when I enter the items
description on my screen? For instance, if I enter product type, size
and color . . .I want a specific price to appear in a box. How do I
make this happen? Would this take place on a "form" or some other type
of "sheet"?
Click to expand...

It would indeed be a Form.

You do not describe how your tables are structured, but presumably you
have a Table with prices, and this table can be searched by type, size
and color. You would need to have a little bit of VBA code on the Form
to accept the user's choices for these and navigate to the desired
record. Without knowing anything about your table or form structure I
can't be specific about the code.
I don't want to have to open a report to see it, I'm
hoping to get it to show up on the screen I'm working on and such that
if I change one of the description fields, the price would change
accordingly.
Click to expand...

WHat if you change the text in the description and the new text
doesn't have any records in the table!? I'm not sure what you're
saying here. You may be able to use a Combo Box to SELECT existing
values, but to have a textbox into which you can freely type any
description you like doesn't seem like it would be useful.
It's like in DOS when you type in a customer name and
all of their pertinent info shows up on the screen.
Click to expand...

You're talking about some particular application which someone
programmed (in a DOS environment). DOS, by itself, does *not* do this.

John W. Vinson[MVP]
 
Back
Top