Transfer Data between forms

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
 

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

Similar Threads

transfer data between forms using Macro and VBA 1
Ato generated control number 1
Passing data between forms 4
List Box not saving to bound field. 3
Disable fields in a form on open & enable with button click data e 2
Click a subform field to open relevant form 5
append query for associate entity 2
filling fields on linked forms automatically 2

Top