Hide button on Continuous form show only on new record (at bottom)

[mchadwick]

I have a subform that is a continuous records form I am using and want to add a button on the last record\new record. I have it set up now so that the button is on every record in the subform and it works just fine, but it is only part of the new record so, I dont get the desired effect if someone presses the button on a record that is not new. Easily fixed with training, but I would really like to know how or if I can do that.

The button is currently launching a macro.

[pbaldy]

I don't think you can hide it in such a way that it's visible for the new record at the same time it's hidden on older records. Code will apply the same treatment to all. You could add code to only run the macro for a new record:

If Me.NewRecord Then

[mchadwick]

Oh I like that, what do I need to add to the macro to make that work. The embedded macro goes to a control then sets property value and then opens a form.

[pbaldy]

What I posted is VBA code; I'm not sure how to test for new record in a macro, as I don't use them. If you want to convert to VBA, none of that looks difficult.

[Missinglinq]

Actually, like Paul, most of the experienced developers, here, don't use Macros. But some testing shows that placing

[NewRecord]=True

under the 'Condition' in your Macro, to the left of the 'Action,' does the job.

But you really should take the time to learn VBA. It's much more flexible, and you only have to go to the code module to see everything that is going on in your Form, rather than having to open each Macro, in turn. This makes figuring out what is going on in your Form, or more importantly, what is going wrong in your Form, much less labor intensive.

Linq ;0)>