Totally Befuddled

[Guest]

OK. I have a text field in a table. In form design, I create a combo box
for that same field. I open form view and the combo box works fine. I do the
same thing for another table and form design and when I try to open the form
view, I get "type mismatch in expression". Everything seems to be the same
in both cases. Why do I get different results?

 

[Jeff Boyce]

Any chance one of those "text" fields is actually set up as a "lookup" field
in the table(s)?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

I don't think so, but I'll check to be sure.
--
Rich D
Armstrong Custom Homes
Redmond

Any chance one of those "text" fields is actually set up as a "lookup" field
in the table(s)?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Nope. they're both just "text"
--
Rich D
Armstrong Custom Homes
Redmond

I don't think so, but I'll check to be sure.

 

[Guest]

What is the row source of the combo box? What is the bound column? If you
have more than one column, maybe the combo box is trying to store a value
from a different column than you are expecting.

 

[Guest]

Just a single column. I've checked and it is bound to the correct field in
the table.

 

[Jeff Boyce]

Rich

Your original post said that you get the "type mismatch" when you open the
form. Does this mean you don't even get to the combo box before this
happens in the second form?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/