VBA: Userform Access

[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.

 

[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