Re: Last try PLease Help!!

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!!!!





.