The value you entered isn't valid for this field.

[Stapes]

Hi

I keep getting this erroneous error message every time I cursor
through this Combo box field. It says you may have entered text im a
numeric field.

It has Row Source: SELECT [Titles].[ID], [Titles].[Title] FROM
[Titles] ORDER BY [Title];
where [Titles].[ID] is an Autonumber field and [Titles].[Title] is
text.

The Bound Column is 1.
Column Count 2
Column Widths: 0cm;4.101cm

The field is meant to display the text.
What is going wrong here?

Stapes

 

[Douglas J. Steele]

What's listed as Control Source of the combo box?

 

[Stapes]

What's listed as Control Source of the combo box?

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)

Hi

I keep getting this erroneous error message every time I cursor
through this Combo box field. It says you may have entered text im a
numeric field.

It has Row Source: SELECT [Titles].[ID], [Titles].[Title] FROM
[Titles] ORDER BY [Title];
where [Titles].[ID] is an Autonumber field and [Titles].[Title] is
text.

The Bound Column is 1.
Column Count 2
Column Widths: 0cm;4.101cm

The field is meant to display the text.
What is going wrong here?

Stapes- Hide quoted text -

- Show quoted text -

Thanks. I had the Bound Coulmn wrong.