[AccessD] Combo box puzzle

[Gustav Brock]

Hi Tina

> Then, when I attempt to view the record in the form, I get the same error.

If the form can't display an already entered valid date, then something else is going on, not related to your combobox.

/gustav
________________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Tina N Fields <tinanfields at torchlake.com>
Sendt: 28. oktober 2017 21:21:32
Til: ACCESSD
Emne: [AccessD] Combo box puzzle

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

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