Current Form, etc

  • Thread starter Thread starter BenBen
  • Start date Start date
B

BenBen

I have a form named Delegates with the following fields:

First Name,Last Name,Address1,Address2,City,Sate,Phone,
Email.

My second form is named Payments and has the following
fields:

First Name, Last Name, City, Conference Fees,
Accomodations, Food, Beverage, Other Receipts.

Question 1. I have a report that prints all the fields
except City from the form Payments. What code can I use to
have the report only select the open form as the record
source as I want to print the report from a command button
on the form after someone has paid? At present, I get all
the persons who have paid printed each time.

Question 2. The Delegates form is normally completed prior
to the conference day. However, if someone shows up on the
conference day, I would like to register the person from
the Delegates form and click a command button on this form
to take me to the Payments form which will display the
person registering rather than the first record. How can I
do this?

How I made sense.
 
1) You should have a unique field for each record. In the DoCmd.OpenReport call, set the
WhereCondition parameter to this value to limit the report to the record with that value.

2) You can use the response to #1 with the OpenForm method also. This will open the form
filtered to the record you select. If you want to see the other records, just turn the
filter off by clicking the filter button on the toolbar.
 
Back
Top