error Popup on close

[yessir]

Desperate - error Popup on close

Hello,

I have a form that has in the original db many popup forms linked to (not the best but i had no choice)

but there are 2 problems. I need to have the autonumber field on the form to feed the popups so when the form closes it says this:

ENTER PARAMETER VALUE
"Forms!frmClient!txtClient_ID"

then if you hit cancel it closes.

second if i close without saying i want to save it still saves it anyway! (big problem)

Could someone please help with these 2 little things?
~Thanks!

 

[yessir]

Please

I really need help with this one!

 

[yessir]

Sorry, my haste caused waste an i did not properly explain.

When you open the select client form and select to "Add a new client" from the button in the bottom right it takes you to the client form.

if you close the client form, the 2 problems occur.

1. I need to have the autonumber field on the form to feed the popups so when the form closes it says this:

ENTER PARAMETER VALUE
"Forms!frmClient!txtClient_ID"

then if you hit cancel it closes.

2. if i close without saying i want to save it still saves it anyway! (big problem)

Sorry for the laxity on my part and thank you for the consideration.

 

[Ukraine82]

Yessir,

You don't want your AutoNumber(clientID) to give a new number unless you finish adding a new record?

Michael

 

[yessir]

can you please elaborate on a solution?

 

[Ukraine82]

I understand what you're saying. Try to enable the close button after the information is completed.

or

Make certain fields to be filled in before closing the form.

hth,
Michael

 

[yessir]

but what if they open the form and then decide that there is nothing to enter and wish to go back?

 

[Ukraine82]

Yessir,

Sorry for the delay I got held up at the office.

I looked at your vb code in add new client command button your vb code (frmselectClient) is assigning the autonumber as you open the frmclient.

hth,
Michael