Data input form set to after last record **

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Thanks alot,Steve

It work well

PA

SteveS said:
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
Click to expand...
 
Back
Top