Copying info from a query to a form (via selection from combo box)

[sandy2011]

Hi Hello all..

Can anyone help me?

I have a query with lots of records/orders on it... I have created a form with a combo box to list the orders by order ref..

I want to select an order number....

then copy some of the fields relating to this order number to another form.. (add new record)...

any ideas.. only a newbie so it would need to be simple..

thanks in advance!!

 

[John Big Booty]

Welcome to the forum.

You could do this in a number of ways the first would be to use the OpenArgs portion of the OpenForm Command. To do this you would need to combine all the info you wish to send to your new record in to one string and then break it down in the On Load event of the form being opened.

The other would be to use an append query to append the required info into the correct table and then use the GotoRecord command to GotoLast once the form has been opened.

 

[sandy2011]

Hi John

Kewl, I will have a look..

Many thanks!