[MS_AccessPros] Clearing all controls in the header with an exception

 

I have code to clear all controls in the Form's header without naming each one. Problem is that one of them (Nmbr) has = Count(*) in its control source. How would I insert to skip Nmbr?

Here's the code for the relevant portion:

'Clear all the controls in the Form Header section.
For Each ctl In Me.Section(acHeader).Controls
Select Case ctl.ControlType
Case acTextBox, acComboBox
ctl.Value = Null

Thanks much!
Connie

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 8
• New Files 1

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___