Combo Box Input

[Guest]

Hi I have a combo box that takes dates from a table. I want to put that date
in the field of another table that i have created a form for. The format for
the date in the [Date Table] is date/time short date. The format for the
field in the table with the form is the same.. Every time that I select a
date for imput I recieve a message that says The Value that entered is not
valid for this field..

Please what am I doing wrong?

Thanks Bob

 

[Allen Browne]

Remove anything you have in the Format and Input Mask properties of the
field in the table, and also of the text box on your form.

If it still fails, post an example of a date you are trying to type.

Also tell us what you have as the Short Date setting in the Windows Control
Panel, under Regional Options.

 

[Bob Quintal]

Ok I have taken the format out of everything all tables
including the lookup table that has the date stored...

my short date setting is shown as 8/9/2007

I have no problem if I just do a regular text box input on the
form the problem is when I do a combo box getting the dates
from the the [dates] table..

Thanks for your help..

Are you using the Lizard to bould your combo box? It may be trying
to put a hidden autonumber column from your dates table into the
new data field.

To check, review the combo box row source and bound column
properties.

 

[Guest]

Ok I have taken the format out of everything all tables including the lookup
table that has the date stored...

my short date setting is shown as 8/9/2007

I have no problem if I just do a regular text box input on the form the
problem is when I do a combo box getting the dates from the the [dates]
table..

Thanks for your help..

Remove anything you have in the Format and Input Mask properties of the
field in the table, and also of the text box on your form.

If it still fails, post an example of a date you are trying to type.

Also tell us what you have as the Short Date setting in the Windows Control
Panel, under Regional Options.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi I have a combo box that takes dates from a table. I want to put that
date
in the field of another table that i have created a form for. The format
for
the date in the [Date Table] is date/time short date. The format for the
field in the table with the form is the same.. Every time that I select a
date for imput I recieve a message that says The Value that entered is not
valid for this field..

Please what am I doing wrong?

Thanks Bob