Setfocus on a datasheet view

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

Guest

I have a subform in datasheet view which consists of a Date and a Quantity.
When the first date is entered, it automatically sets the following date to
be one week ahead. I would like to have the focus set on the Quantity column
so that the user does not have to hit enter twice to get to the Quantity.
Note that after entering the Quantity, the cursor jumps to the Date column
which is automatically filled in.

I tried Quantity.setfocus on the afterupdate event of the Quantity control
but that doesn't seem to work.
 
If the user can't edit tis fields you can set this fields properties
Locked = Yes
Enabled = False
 
The user should be able to change the start date so I just set the tab stop
to NO.
Thanks for the suggestion. I'll actually use it in another part of my D/B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel get a calculated value to land on a specific date 0
Calculating a value in a form that fills in the original table 1
Autonumber with a datasheet view 1
Report layout 1
Filter dates by Saturday 1
Access sub form help needed 2
I want access to ask for a number then use that number to print la 1
Using combo box to add new records and search for existing records 2

Back
Top