Command button on a continuous form

[Jac Tremblay]

Hi,
I have a subform that lists all the records linked to the main form's
record. Naturally, there is a new record at the end of the list. I put a
command button on that subform so that the user can edit the corresponding
record. But the problem is that all the command buttons are enabled (on every
single row, even the new record row). I would like to enable only the one
occurrence that is on the selected record.
Is that possible?
Thanks.

 

[Arvin Meyer [MVP]]

No, what you probably need to do is to put the command button in the form's
geader or footer.

 

[Jac Tremblay]

Hi Arvin,
Thanks for your reply. I knew in the back of my mind that this was not
possible but I wanted confirmation.
I tried to use the current record number, it's ID, and a combination of
those, nothing works. When you code:
Me.cmdWhatever.Enabled = False
all the buttons are disabled. Actually, there is only one button.
I have never tried the conditional formating. I was hoping for some miracle
solution.
Thanks you again, Arvin.