subform problem

[Greg]

I have a main form where I enter data for an auction. The subform is to
enter info for the buyers. As there can be more than one buyer the subform
takes any number of buyer number, premium and base_price for as many buyers
as want to split that item. I have to tab out of the subform after entering
the last buyer. The next time I enter the subform, the cursor is on the last
item in the list (base_price) instead of on the first item (buyer number)
where I want it. I have to backtab twice every time I enter this subform to
start entering the next buyers info. Is there anyway to control which field
the subform goes to when you first enter the subform? Or is there a way to
program in a couple of backtabs in a marco or something?

Thanks for any help.

 

[Marshall Barton]

I have a main form where I enter data for an auction. The subform is to
enter info for the buyers. As there can be more than one buyer the subform
takes any number of buyer number, premium and base_price for as many buyers
as want to split that item. I have to tab out of the subform after entering
the last buyer. The next time I enter the subform, the cursor is on the last
item in the list (base_price) instead of on the first item (buyer number)
where I want it. I have to backtab twice every time I enter this subform to
start entering the next buyers info. Is there anyway to control which field
the subform goes to when you first enter the subform? Or is there a way to
program in a couple of backtabs in a marco or something?

I think you are supposed to tab or enter out of the control
before using shift tab to leave the subform.

Try using the subform control's Enter event to set the
focus:
Me.subformcontrol.Form.firstcontrol.SetFocus