Print or display receipt for current record in continous form?

  • Thread starter Thread starter scs
  • Start date Start date
S

scs

I have a form in my database called frmCustomer which has a continuous type
subform called fsubPayments. I'd like to optionally display and then
optionally print a receipt when I enter a payment into the fsubPayment form.
I am lost on how to go about this. So far I am imagining a little button on
each record of the continuous form. I would click the button to display a
report for just that record. What needs to be done (query, report)? How do
I filter the report for just one record on the continuous form? I would
really appreciate any suggestions about how to best go about this.

TIA
Steve
 
Your subform records will come from a table that has a primary key field.
You can open your receipt report filtered so it contains just that one
value.

Example code for the Click event procedure of your button in this article:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

Note that Access will automatically supply the value for the selected row in
the continuous form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top