Carrying fields from one form to another

  • Thread starter Thread starter sgricus
  • Start date Start date
S

sgricus

Hi!

I am creating a very simple database for the Theater Company. I have a
form (called frmPeople), that lists the BuyerID, Last Name and First
Name of a ticket buyer. The form also lists the ticket history,
adress....etc.
From this form, you click on the "Buy Tickets" button, and it takes you
Click to expand...
to frmPurchase, which allows you to choose the performance, etc.

What I want to do is create some sort of "event" where when you click
on "Buy Tickets", frmPurchase will pop-up with the BuyerID, Last Name
and First Name that you were on when you were on frmPeople.

Every time I try to create a macro, it says it doesn't work.

ANY IDEAS?!?!?!?!?!?!?
 
Hi,

If frmPeople will always be open when you open frmPurchase,
set the default value properties for frmPurchase

BuyerID --> DefaultValue -->
= nz(forms!frmPeople!BuyerID)

Last Name --> DefaultValue -->
= nz(forms!frmPeople!Last_Name)

First Name --> DefaultValue -->
=nz(forms!frmPeople!First_Name)

Warm Regards,
Crystal
MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
Back
Top