get access to control on same line in detail section as selected contr

[mea5720]

I think this *must* be easy...

I have a detail section that in design view has a couple of controls:
txtFoo cmdFoo

I want to gray out the command button on the line in the detail section whose text box is being edited. Of course, when I say "cmdFoo.Enabled = False", all of the command buttons in the detail section gray out. How can I find out which record is actually being edited and gray out only that one cmd button?

Thanks!
Michael

 

[JerryDennison]

This must be a continuous form. You cannot change the property of a control without affect all of the same control on all rows of the continuous form. You can, however have Access change the background color of text controls that will only change for the active field. This can be done without using code. I believe there is a FAQ on this. I'm sorry I can't point you to it maybe some other kind soul will?