Type Mismatch Problem

[Hootie]

Within a form I am trying to requery a combo box. I am using the code:
Me.ComboBox.Requery
I get an error message saying "Type Mismatch"
What does this mean?

Any help is appreciated.

 

[Andy Cole]

Hootie

If your combobox is actually called 'ComboBox', you are confusing Access as
ComboBox is a Type (in this case, of a particular style of control). Change
your combo's name to something more applicable to the data it holds - for
example if your combo list contains names, call it cboNames. The same
problem will be found if you called a textbox control 'TextBox' or a listbox
control 'ListBox'

HTH

Andy

 

[Andy Cole]

Hootie

If your combobox is actually called 'ComboBox', you are confusing Access as
ComboBox is a Type (in this case, of a particular style of control). Change
your combo's name to something more applicable to the data it holds - for
example if your combo list contains names, call it cboNames. The same
problem will be found if you called a textbox control 'TextBox' or a listbox
control 'ListBox'

HTH

Andy

 

[Andy Cole]

Hootie

If your combobox is actually called 'ComboBox', you are confusing Access as
ComboBox is a Type (in this case, of a particular style of control). Change
your combo's name to something more applicable to the data it holds - for
example if your combo list contains names, call it cboNames. The same
problem will be found if you called a textbox control 'TextBox' or a listbox
control 'ListBox'

HTH

Andy