Re: Last try PLease Help!!

It worked!!!! I have been trying to do all kinds of workaround and finally
something worked. Thank you so much for your help, it is most
appreciated!!!!! This board has help me in many situations and I hope to
someday be able to help others on here.

Thanks again Susan!!!

"SusanV" wrote:

Hi Doug,

In that case, you would use the OnClick of the button to reset the visible
property, something like

Me.btnCalculate.Visible = True

I haven't tested this against a "live" form, and the On Current *may*
over-ride this reset - let me know if it does.

SusanV

"Doug_C" <DougC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A4418D8F-D3A1-44E5-B83A-7513326D7F3B@xxxxxxxxxxxxxxxx
Hi Susan,

This works great!! Except, I have an edit button that allows edit when a
password is entered. When I click on the edits button, I would like for
the
cmdCalculate button to be visible. If you know how to do this last step, I
will be finished and ready to present.

Thanks!!!!

"SusanV" wrote:

Assuming the button is called btnCalculate, use the On Current Event of
the
form and show the button only if this is a new record:

Me.btnCalculate.visible = Me.NewRecord

--
hth,
SusanV



"Doug_C" <DougC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A196E2B1-B195-4F1E-BB87-05B6B3CDF91B@xxxxxxxxxxxxxxxx
Hello,

Ok, I will make this simple. I have a form that opens to a new record,
say
this one is record #23. Once the information has been entered and the
user
clicks AddRecord (now showing record #24) if the user goes back to
record
#23, I want the Calculate button to be "Invisible". How do I do that?
Please
simplify and if it is with VBA, please let me know which control and
event
to
enter it.

Thank you much!!!!






.