Cursor position upon opening form

[CW]

Using A2003, I have a continuous form on which we enter details of invoices
paid for supplies on each production job. Whenever the form is opened (which
is typically for the purpose of entering details of another invoice) we need
the cursor to be sitting in the first control of the new empty row, which is
the last (lowest) one on the form. However, it is always in the topmost row
i.e. an existing record, and the user has to click into the new row (or
sometimes forgets and over-writes an existing record!).
I have tried to use the On Load and On Open events to force the cursor into
the new empty row but cannot get it to behave - how can I do this please?
Many thanks
CW

 

[Dirk Goldgar]

Using A2003, I have a continuous form on which we enter details of
invoices
paid for supplies on each production job. Whenever the form is opened
(which
is typically for the purpose of entering details of another invoice) we
need
the cursor to be sitting in the first control of the new empty row, which
is
the last (lowest) one on the form. However, it is always in the topmost
row
i.e. an existing record, and the user has to click into the new row (or
sometimes forgets and over-writes an existing record!).
I have tried to use the On Load and On Open events to force the cursor
into
the new empty row but cannot get it to behave - how can I do this please?

What have you tried?

RunCommand acCmdRecordsGoToNew

in the Load event ought to position you at the new record.

 

[CW]

Great - that did it!
Many thanks Dirk
CW

What have you tried?

RunCommand acCmdRecordsGoToNew

in the Load event ought to position you at the new record.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)