[AccessD] Combo box puzzle

[Anders Ebro (TheSmileyCoder)]

Does the field have an input mask?
Send screenshots of the field properties of both tables, as well as the combobox, and maybe something till stand out.

Sent from my mobile device, and thus kept brief.

On 28 Oct 2017, at 21.41, Tina N Fields <tinanfields at torchlake.com> wrote:

Hi again,

Update. If I use a value list for the combo box, rather than the date from the date table, it works.

So, why didn't I want to do it that way? Because, next year someone will need to edit that value list rather than the two records in the date table.

Still don't know why that wasn't working.

Ideas?

T

Tina Norris Fields
231-322-2787
tinanfields-at-torchlake-dot-com

> On 10/28/2017 3:21 PM, Tina N Fields wrote:
> Hi,
> 
> There is a table with just two date records - December 14, 2017 and December 15, 2017. These are pickup dates for Christmas food baskets. The date field is set to 'short date' or 12/14/2017 and 12/15/2017.
> 
> The selected date is to be stored in a date field in the family record in the households table.
> 
> On the data-entry form, I placed a combo box (using the wizard), to select the values from the tblChristmas_Pickup_date table and store it in the HH_Christmas_Date field in the tblHouseholds table. The field is set to short date.
> 
> Testing the data entry, as soon as I select the date from the combo box, I get this 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.
> 
> I can go into the tblHouseholds table and put the date in that field. Then, when I attempt to view the record in the form, I get the same error.
> 
> What the heck am I doing wrong?
> 
> Thanks,
> T
> 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com