Enable button only when there is at least 1 record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to keep a record entry button disabled only until a record is entered
in the subform and then keep it permanently enabled.

thanks
 
Use the subform's oncurrent event and do a recordcount. if recordcount>0
then enable the control on the main form else disable.
 
I inserted the following into a text box in the subform and named the
control "RecCount"

=RecordsetClone.RecordCount

This works fine but now I am not entirely sure what to put in the
"oncurrent" event. I am not sure how to reference the button in the code..
 
You must log in or register to reply here.

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

Macro doesn't work first time form is opened. 2
Record Selector. 6
Access Automatically Send a notification email once a record is added 0
How to prevent subform entry until parent record exists 4
How to enable New/Delete record button when a form opened? 4
New Parent Record from Navigation Buttons 2
Repost from 6/18: New record in subform for info on main form 2
Pop-up form that creates record that links 1:1 to main form 0

Back
Top