Compile Error: Argument Not Optional | Access VBA

Question

I have a form on Access where I have 3 ComboBoxes (Section, Rooms: White House, Rooms: Churchills). I need to have it so when 'White House' is selected from the 'Section' ComboBox, 'Rooms: Churchills will be Locked. And the opposite for 'Churchills'.

I have the code:

Private Sub Section_Change()
If Section.Value = "White House" Then
  Rooms__White_House.Enabled = True
  Rooms__Churchills.Enabled = False
Else: Section.Value = "Churchills"
  Rooms__White_House.Enabled = False
  Rooms__Churchills.Enabled = True
End If
End Sub

But when I test the form it throws the error:

Compile Error: Argument Not Optional

Any Help Appreciated. Thanks in Advance!

It always helps to tell us what line the compiler breaks on. It saves time, and often the problem can be determined by inspection. — DeanOC
– DeanOC, Commented Mar 22, 2015 at 0:35

DeanOC · Accepted Answer · 2015-03-22 00:34:24Z

1

The problem is that Section is a reserved word. So the compiler doesn't recognise it as the name of your combobox. Just change the name of the combo to something else, e.g. cboSection, and your code will compile. (You naturally need to change your code to match the new name).

This link shows a list of names that you should avoid when working with Access http://allenbrowne.com/AppIssueBadWord.html

BTW, your line

Else: Section.Value = "Churchills"

seems a bit odd as it is setting the value of the combo. I'm guessing that you are meaning to comment what the value must be if you enter the Else section. If that's the case then you need to add the apostrophe in front of the comment, i.e.

Else: 'Section.Value = "Churchills"

answered Mar 22, 2015 at 0:34

DeanOC

7,3326 gold badges44 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Stephen Palmer Over a year ago

Hello DeanOC, How are you today? I done what you said and it is now working. I have also bookmarked your link. Thanks for your help! I did mean to comment it yes, It has been one of those weeks haha. Thanks again man.

Collectives™ on Stack Overflow

Compile Error: Argument Not Optional | Access VBA

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related