Transfer Data between forms

  • Thread starter Thread starter Charlienews
  • Start date Start date
C

Charlienews

Hi,

I'm not sure if this can be achieved but I am trying to do the following:

I have a button which runs a macro to open a new order with all fields
empty. I want to add some code that will populate the corresponding fields
from the quote e.g. CompanyID, Contact ID, Job Description, Title etc.

I would use the following code to populate the fields:
[Customer] = Forms![Quotes]![Customer]
[JobDescription] = Forms![Quotes]![JobDescription]

What I need ideally is code that will open the form and populate the
relevant fields without the need for the macro. Everytime I use the wizard
when I create the button, it gives me all the orders which is not helpful.

Any suggestions would be great.

Thanks in advance

Charlie
 
Back
Top