reload short date in text box

[Keith H.]

Hi all;

I am attempting to reload the values of text and combo
boxes into a form as it advances to the next new record.
I've had problems reloading the short date back. Access
keeps returning the 12:00am time into the box which write
a year 1899 date to the table. How do I distinguish just
the current date value?

Next question... in a combo box I'm doing the same thing
but the value written to the table is not the value that
appears in the combo box.

I've created a variable to save the value as the field
default. It seems to work on the other boxes but not
these two. Any ideas? The purpose is to speed up data
entry for the operator by having recurring values
reappear so they don't have to be typed each time.

Thanks in advance for any help.
Keith

 

[Arvin Meyer]

In line:

Hi all;

I am attempting to reload the values of text and combo
boxes into a form as it advances to the next new record.
I've had problems reloading the short date back. Access
keeps returning the 12:00am time into the box which write
a year 1899 date to the table. How do I distinguish just
the current date value?

The simple way is to use Ctrl + ; (the control and semi-colon keys)

Next question... in a combo box I'm doing the same thing
but the value written to the table is not the value that
appears in the combo box.

Make sure the column bound to the field in the table is the same as the one
bound to the control in the form, and displayed in the combo box. The
combobox bound column is usually the first column. Just look on the property
sheet on the Data tab, and all will be revealed.

I've created a variable to save the value as the field
default. It seems to work on the other boxes but not
these two. Any ideas? The purpose is to speed up data
entry for the operator by having recurring values
reappear so they don't have to be typed each time.

Default values are only for new records. Also make sure that you are trying
to store the correct datatype in the control. (i.e. you cannot store
currency in a date field)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access