Form_ComboBox Cancel Button undo's info

[Brook]

To All:

I have a form with a combobox that uses a lookup to a
table if certain combobox (based on a client table)
properties are true. Once the user chooses the
client/company they want for the lookup from the combobox
they click ok and it used an autofill from the client
table to fill other fields on the form from the client
table. However, if the user chooses to cancel, I want all
combo box selections to be void and not save, how can I
accomplish this?

I.E I have a combobox that drops down to "In-
Transit", "Warehouse" and "Consignment". When the user
chooses "Consignment" a popup form comes up for the user
to choose the Client from the table and then clicks "OK",
the client from the pop-up will fill in on the form
for "ForClient". However, if the user decides to click
the "Cancel" button on the pop-up form, I want any
selections made to not save therefore all the original
information be available on the form.

Please let me know if you have any questions!

Thanks in advance for your help!

Brook

 

[Jonathan Parminter]

-----Original Message-----
To All:

I have a form with a combobox that uses a lookup to a
table if certain combobox (based on a client table)
properties are true. Once the user chooses the
client/company they want for the lookup from the combobox
they click ok and it used an autofill from the client
table to fill other fields on the form from the client
table. However, if the user chooses to cancel, I want all
combo box selections to be void and not save, how can I
accomplish this?

I.E I have a combobox that drops down to "In-
Transit", "Warehouse" and "Consignment". When the user
chooses "Consignment" a popup form comes up for the user
to choose the Client from the table and then clicks "OK",
the client from the pop-up will fill in on the form
for "ForClient". However, if the user decides to click
the "Cancel" button on the pop-up form, I want any
selections made to not save therefore all the original
information be available on the form.

Please let me know if you have any questions!

Thanks in advance for your help!

Brook
.

Hi Brook,

me.undo ?

Luck
Jonathan

 

[Brook]

Where would I place this code?

Brook

-----Original Message-----

Hi Brook,

me.undo ?

Luck
Jonathan
.