Query in Form Problem

  • Thread starter Thread starter Jeremy Dove
  • Start date Start date
J

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
 
DoCmd.GotoControl "Forms!frmMainForm!FieldName"

You would place it in the Lost focus section of the last
field on the subform.
 
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 ?
Click to expand...

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?
Click to expand...

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