By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,201 Members | 937 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,201 IT Pros & Developers. It's quick & easy.

Tab from list box to subform control, Access 2000

P: n/a
On a form, I have a list box and a subform. After a name is selected
in the list box, I would like for the cursor to automatically tab to
the first field in the subform. Can someone give me a tip on this?

TIA,
JD
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
jd****@yahoo.com (jd****@yahoo.com) wrote in message news:<75**************************@posting.google. com>...
On a form, I have a list box and a subform. After a name is selected
in the list box, I would like for the cursor to automatically tab to
the first field in the subform. Can someone give me a tip on this?

TIA,
JD


Why not just use a combobox? If you are not using the Multi-select
property of the listbox, then I would think a combobox would be
easier...
Nov 13 '05 #2

P: n/a
Thanks. I wasn't using the multi-select property of the listbox and
the combobox does look better on the form. But I still can't get the
cursor to automatically tab to the first field in the subform. Is
there some code I can put in the after update property of the combobox
to do this?

TIA,
JD

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...
jd****@yahoo.com (jd****@yahoo.com) wrote in message news:<75**************************@posting.google. com>...
On a form, I have a list box and a subform. After a name is selected
in the list box, I would like for the cursor to automatically tab to
the first field in the subform. Can someone give me a tip on this?

TIA,
JD


Why not just use a combobox? If you are not using the Multi-select
property of the listbox, then I would think a combobox would be
easier...

Nov 13 '05 #3

P: n/a
Thanks, but I solved my problem (with the help of this NG). In the
after update property of the combobox, I put the following code:

Forms!frmRollStockFreight!sbfrmRollStockFreight.Se tFocus
Forms!frmRollStockFreight!sbfrmRollStockFreight.Fo rm!FreightBillNo.SetFocus
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...
jd****@yahoo.com (jd****@yahoo.com) wrote in message news:<75**************************@posting.google. com>...
On a form, I have a list box and a subform. After a name is selected
in the list box, I would like for the cursor to automatically tab to
the first field in the subform. Can someone give me a tip on this?

TIA,
JD


Why not just use a combobox? If you are not using the Multi-select
property of the listbox, then I would think a combobox would be
easier...

Nov 13 '05 #4

P: n/a
jd****@yahoo.com (jd****@yahoo.com) wrote in message news:<75**************************@posting.google. com>...
Thanks. I wasn't using the multi-select property of the listbox and
the combobox does look better on the form. But I still can't get the
cursor to automatically tab to the first field in the subform. Is
there some code I can put in the after update property of the combobox
to do this?

TIA,
JD


probably in the LostFocus event of the combobox, put code that sets
focus to the subform.
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.