prompt user if changing customer

[DougP]

I made a form where the user chooses a customer from a combo box. Sometimes they forget to make a new Order so they are changing the customer for order number one. Of course they change everything and now Order Number 1 has been change numerous times and the previous number 1's are all gone.
so we have no record of anything.
How can I prompt for "Are you sure you want to change the customer?" so they don't do this anymore!

I tried want to save the customer name somewhere prior to them changing it but have not had any luck with Before_update, On_enter or others in the combo box..

TIA




DougP
< I Built one

http://www.robots2000.com

 

[TheAceMan1]

How are ya DougP . . .

What if you [blue]only allow writing to a new record?[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[MajP]

You can do this on the before update event of the combo.
1)Check if a new record
2)If not a new record then prompt
3)If they want to cancel then cancel the event.

 

[DougP]

MajP, how do I check for a new record?

DougP
< I Built one

http://www.robots2000.com

 

[TheAceMan1]

DougP . . .

[blue]   If Me.NewRecord Then
      [green]'Prompt[/green]
   Else
      Cancel=True
   End If[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]