Problem with Subform opening a form with subform

[akinia]

Hello everybody,
First I'm using Access 97.

I've a form which gives some informations about customers.
In this form I've a subform which shows (in datatsheet form) the last status for products where the customer is interested in.
When I double click in the status field it opens a new form (created by a sql statement, not a table) retrieving the customer ID (from the form and no the subform), the product name using the expression builder(from the subform)in the form header; in the detail form I have a subform (in datatsheet form) which retrieves all the status for the same product and the same customer since the beginning.
My problem is that the focus always returns to the first field (which is the PK) when I go to the next record.


Any suggestion will be appreciated.

Thanks and good W-E.

Akinia

 

[HomeALone]

Put the following code in your “On Open” Event of the form

Me.FieldName.SetFocus

This will take the focus to whatever field name you want. Hope this helps.