Closing form and updating a form

's Computer Specifications

I have a order form that has a button that lets me add another
Delivery address for the Account customer that is placing the order.

When i press the buttotn it opens up the forms and puts the AddressID
number on it and also the account number is related to

I how want a button on the Delivery address form that will close the
form and put the DeliveryID number into the frmOrder.DeliveyrNumber

Thanks

's Computer Specifications

Simon,

Something like this?...

DoCmd.RunCommand acCmdSaveRecord
Forms!frmOrder!DeliveryNumber = Me.DeliveryID
DoCmd.Close acForm, Me.Name

--
Steve Schapel, Microsoft Access MVP

Simon wrote:
> I have a order form that has a button that lets me add another
> Delivery address for the Account customer that is placing the order.
>
> When i press the buttotn it opens up the forms and puts the AddressID
> number on it and also the account number is related to
>
> I how want a button on the Delivery address form that will close the
> form and put the DeliveryID number into the frmOrder.DeliveyrNumber
>
>
> Thanks
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
newbie- updating linked tables on form closing	Keith R	Microsoft VB .NET	2	3rd Dec 2006 04:27 AM
Updating a combo box without closing form	=?Utf-8?B?Um9u?=	Microsoft Access Forms	4	6th Jun 2006 05:01 PM
Updating a table when closing a form	=?Utf-8?B?ZG12MTk0Nw==?=	Microsoft Access Forms	1	23rd Jan 2006 06:23 PM
Updating a table after closing a form.	=?Utf-8?B?RnJhbms=?=	Microsoft Access	3	16th Aug 2005 09:32 PM
Opening Closing and updating subform or form	John Evans	Microsoft Access Forms	3	23rd Aug 2003 03:11 AM