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.
--
Jac Tremblay

No, what you probably need to do is to put the command button in the form's
geader or footer.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Jac Tremblay" <(E-Mail Removed)> wrote in message
news:1FF9646D-46EF-47AC-97AA-(E-Mail Removed)...
> 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.
> --
> 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.
--
Jac Tremblay


"Arvin Meyer [MVP]" wrote:

> No, what you probably need to do is to put the command button in the form's
> geader or footer.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.accessmvp.com
> http://www.mvps.org/access
>
>
> "Jac Tremblay" <(E-Mail Removed)> wrote in message
> news:1FF9646D-46EF-47AC-97AA-(E-Mail Removed)...
> > 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.
> > --
> > Jac Tremblay
>
>
> .
>