Data input form set to after last record **

[Guest]

Dear All,

I create a form for data entry\input, every time I open the data entry form
it always show the first record.

The table which is the source of that form looks like that:

ID Client Data Total Units Error unit
11 AAA 1/1/06 10,000 500
12 BBB 3/3/06 30,000 700
14 CCC 4/4/06 15,000 456

The Form for data input (always show the first record every time I open the
Data Input Form)

ID 11 -----always show the first record data
Client AAA
Date 1/1/06
Total Units 10,000
Error Units 500


I wish the DataInputForm that when we Open for new input- will show blank
data or record after the last record (except date –default to today date/now),

Appreciate if can get advise what I need to set up at Form Property or any
VB Code that I need to put in at Form’s VB module(?)

Many thanks

PA

 

[Guest]

PA,

Open the data input form in design view.
Open properties - click on the DATA tab.
Set the property "Data Entry" to YES. (ALLOW ADDITIONS must also be set to
YES)
Save the form.

The form will *always* open in data entry mode (ie a new record), until you
change the property back to NO.

For a date control in a new record to be set to today: with the properties
dialog open, click on the control (for the date) then the DATA tab. Set the
DEFAULT VALUE property to DATE()

HTH

 

[Guest]

Thanks alot,Steve

It work well

PA

PA,

Open the data input form in design view.
Open properties - click on the DATA tab.
Set the property "Data Entry" to YES. (ALLOW ADDITIONS must also be set to
YES)
Save the form.

The form will *always* open in data entry mode (ie a new record), until you
change the property back to NO.

For a date control in a new record to be set to today: with the properties
dialog open, click on the control (for the date) then the DATA tab. Set the
DEFAULT VALUE property to DATE()

HTH