Fill in a record based on another form!

looneytunes

Registered User.
Local time
Today, 18:20
Joined
Feb 9, 2005
Messages
31
hey every1 - i have once again searched for the soln, however, either the solns involve subfrms or go off on one - and i get confused!
i wud be extremely grateful if any1 can help me:

I have a form - FrmCars - which holds details of cars! This is linked to open FrmInvoice via a command button. The FrmInvoice has the same fields as the FrmCars - but with additional ones - ie. customer details etc.
A report - Invoice - is created and then printed.

What I want to do it when a button on FrmCars is clicked - i want it to keep the Registration Number of the car and automatically show it on my other form - FrmInvoice.
I am not very proficient at Access :o - as u have probably guessed - so I would appreciate any help. thank you
 
For the Code of your button

Forms!YourForm!yourfield=Me!yourfield
 
thank you - works great!!! :D
 

Users who are viewing this thread

Back
Top Bottom