VBA: Userform Access

S

Shon Yim

I created a Userform in my workbook, let's call it MyForm.

Whenever I try to access it, I get an "Type Mismatch"
error. For example, If I try to do something as simple
as:

Userforms("MyForm").Show

or

Userforms("MyForm").ComboBox1.Value = "whatever"

Please help.
 
S

steve

Shon,

If the name of the form is "MyForm" (as seen in the project window) or as
seen in the Properties Window under (Name)
than all you need is
MyForm.Show
or
x = MyForm.ComboBox1.Value
 
Top