Move Form to a new record

[Neal Ostrander]

I have two forms for inputting orders on one form the user selects the
customer, puts in the date of the shipment then clicks a button to open the
second form where order detial are input. Is there a way to make the first
form (customer selection) move to a new record when the user closed the
second form (order details)
Thanks in advance
Neal

 

[Neal Ostrander]

I understand using the new record button. But what I need the forms to do is
when form two is closed from one automatically advances to a new record.
Thanks
Neal

 

[Gina Whipp]

Neal,

On the OrderDetails form you would need to put an event On_Close telling the
Order form to go to a new record. Something like...

Forms!Order.SetFocus
Forms!Order.SomeField.SetFocus
Docmd.GotoRecord , , acNewRec

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Neal Ostrander]

Thanks Gina,
I knew it had to be something simple but it just wasn't coming to mind.
Thanks again
Neal

 

[Gina Whipp]

You're welcome!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm