ComboBox - Value enteres is not valid

[cstimart]

I have a ComboBox on my form, with 2 option buttons. If the user selects option 1, the ComboBox fills the dropdown list (by changing the Row Source SQL) with week-ending dates that the user can select....and there's no error.

However, if the user selects option 2, the ComboBox fills the dropdown list (by changing the Row Source SQL) with 4 digit years. When the user selects one of those, the error appears.

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

I've tried changing the 'Format' of the ComboBox based on the option without any luck.

Any ideas?

 

[cstimart]

In the meantime, I've just created a separate ComboBox.

 

[welshgasman]

Is the combobox bound or unbound?

 

[cstimart]

Is the combobox bound or unbound?

UnBound.

 

[welshgasman]

Would you not need to amend the format if you change the type of data for the control.
Not something I have ever needed to be done TBH.

 

[cstimart]

Would you not need to amend the format if you change the type of data for the control.
Not something I have ever needed to be done TBH.

I only tried changing because I am getting that error.

 

[welshgasman]

Duh, sorry, I just reread your original post, however when you say 'change the format' are you doing it on the fly when you change the record source?

When I have created comboboxes it has always been in the format
ID
Item to display
Other items needed

so I have always been putting the same type value in the control?

You could try that and then just refer to the second column(1) when you want to compare against that value.

I'd like to know if you ever sort it, as I can see it is the sort of thing I might need to do in the future, but I would still construct the data in the way I mentioned above.