Query in Form Problem

[Jeremy Dove]

I have a form w/ subform. The subform is a form that uses
a query as it's datasource.

I also have 3 other forms w/ subforms that have the sub
based on tables.

I have 2 questions.

1. When I am tabbing through the form and then the
subform, after I go through the subform the tab won't
return to the main form. How do I make it do this ?

2. With the form w/ subform based on the query I can't
click on a field in the subform. I have to tab through it
in order to make changes. However when I am using the
other forms w/ subforms I can click on any field and
update all I want. Do you know why this is happening and
how do I make it work correctly?

Thanks in advance

 

[Guest]

DoCmd.GotoControl "Forms!frmMainForm!FieldName"

You would place it in the Lost focus section of the last
field on the subform.

 

[John Vinson]

1. When I am tabbing through the form and then the
subform, after I go through the subform the tab won't
return to the main form. How do I make it do this ?

Ctrl-Tab. Tab will either cycle within a single record on the subform,
or go to the next record (still on the subform), depending on the
subform's Cycle property.

2. With the form w/ subform based on the query I can't
click on a field in the subform. I have to tab through it
in order to make changes. However when I am using the
other forms w/ subforms I can click on any field and
update all I want. Do you know why this is happening and
how do I make it work correctly?

Not a clue! I've never seen this behavior!