Private Sub Form_Current() With Me![StudentInstrument Subform].Form .Visible = (.RecordsetClone.RecordCount > 0) End With With Me![InstrumentServices Query Subform].Form .Visible = (.RecordsetClone.RecordCount > 0) End With ' With Me![InstrumentComments Subform].Form ' .Visible = (.RecordsetClone.RecordCount > 0) ' End With End Sub
|MS Access to SQL Conversion - Bit and Yes/No Datatypes||12||46|
|How to remove the decimal places from a number field within an expression in Access 2010||4||23|
|How to make query not show results in table form go straight to report||4||21|
|I'm trying to format textboxes for each record on a form based on comparative values of two different fields||13||23|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!