Dissable command button

B

Bisha

I have a form and a subform. When I open the main form I
have one commandbutton disabled.I need to enable it as
soon as something is entered on the subform but I cant
seem to be able to reference the Button from the subfrom
change event.

thank you in advance
 
P

PC Datasheet

Put this code in the subform's After Insert event:

Me.Parent!NameOfButton.Enabled = True

--
PC Datasheet
Your Resource for Access, Excel and Word Help

Stephen G. Santus, MBA, Engineer Office (814) 226-5327
52 Campbell Avenue Fax (775) 822-3965
Clarion, PA 16214 (e-mail address removed)

www.pcdatasheet.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
subform selection to change detail record on mainform 2
VBA code returns no records hwenKey ID is added 14
Append Query to Mainform and Subform 0
Need Help on SubForm 5
Question on Going to a Record 3
Append Records from a subform to a new record 1
Referring to control in the active subform 0

Top