Is there any way to create a receipt Form?

[Guest]

I've been trying to work out a form that would serve as a receipt, but it's
not going very well at all. I need my dropdown menu (containing product
names) to place the price in a somehow linked box that the total may be
calculated at the bottom of the reciept. Is it at all possible? If so, can
someone help me out? Thanks in advance.

 

[John Vinson]

I've been trying to work out a form that would serve as a receipt, but it's
not going very well at all. I need my dropdown menu (containing product
names) to place the price in a somehow linked box that the total may be
calculated at the bottom of the reciept. Is it at all possible? If so, can
someone help me out? Thanks in advance.

If you want to "print out* a receipt, use a Report, not a Form. You
can launch the Report using a command button on a form to filter the
report to a specific record if you wish.

Since we know nothing whatsoever about your table structure, your
queries, or your form, it's hard to be specific; but you can use the
Report's Sorting and Grouping dialog to make the Group Footer visible,
grouping by customerID (or whatever grouping is suitable for your
data). In the Footer you can put a textbox with a control source like

=Sum([fieldname])

to sum the numeric or currency values in fieldname.

John W. Vinson[MVP]