E
Eric
I originally posted this on March 19. I am hoping that this time someone can help me. I have been working on other projects, and am just now getting back to this one..
I have a combo box on a subform whose goal in life is to let the user select between one of two values: "Direct" or "Distributor"
I initially had it set up to reference a lookup table, but have switched to a value list in an attempt to get around this confusing error. However, I have had no success
The field (called BuyingMethod) is a text field of 11 chars in length
Here's the problem: The _first time_ I try to pick one/either of the values from the combo box (in a new record), Access returns the error "The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits." Any subsequent attempts to change or re-pick the value works just fine. At least, no error dialog is presented
Another note of interest is that this only occurs when the subform is opened as a subform. In other words, when I open the subform directly - outside of it's main form - and pick one of the values, it does not return this error at all
Anybody have any ideas? I've sat and poured over the properties of the form control, event code (there isn't any), the underlying table(s), etc. I have other similar forms/subforms in this database that do not exhibit this behavior. I've compared back and forth and can't find what's missing or wrong
Any help will be appreciated
Thanks
Eric Levy
I have a combo box on a subform whose goal in life is to let the user select between one of two values: "Direct" or "Distributor"
I initially had it set up to reference a lookup table, but have switched to a value list in an attempt to get around this confusing error. However, I have had no success
The field (called BuyingMethod) is a text field of 11 chars in length
Here's the problem: The _first time_ I try to pick one/either of the values from the combo box (in a new record), Access returns the error "The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits." Any subsequent attempts to change or re-pick the value works just fine. At least, no error dialog is presented
Another note of interest is that this only occurs when the subform is opened as a subform. In other words, when I open the subform directly - outside of it's main form - and pick one of the values, it does not return this error at all
Anybody have any ideas? I've sat and poured over the properties of the form control, event code (there isn't any), the underlying table(s), etc. I have other similar forms/subforms in this database that do not exhibit this behavior. I've compared back and forth and can't find what's missing or wrong
Any help will be appreciated
Thanks
Eric Levy