If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cursor position upon opening form
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 |
#2
|
|||
|
|||
Cursor position upon opening form
"CW" wrote in message
... 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. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
#3
|
|||
|
|||
Cursor position upon opening form
Great - that did it!
Many thanks Dirk CW "Dirk Goldgar" wrote: "CW" wrote in message ... 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. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|