[AccessD] [AccessD]A97 - Get Focus Main Form

Couldn't you use the LostFocus Event of the Comments in the sub form i.e :

In the LostFocus Event type Forms!MainForm!NameCBO.SetFocus

I'm sure I have used something like this in the past

Paul



From: "Terri Jarus" <jarus at amerinet-gpo.com>
Date: Tue 18/Mar/2003 15:16 GMT
To: <accessd at databaseadvisors.com>
Subject: [AccessD] [AccessD]A97 - Get Focus Main Form

I am working in a subform and want to tab from one field back to a field
on the main form.  How do I get focus to the field on the main form?

MainForm - CashReceipts
SubFormControl - SubCashCtl

Field on subform is Comments - once I tab off that field I want the
focus to set to the field  nameCbo on the main form.

I can't seem to get it right - couldn't find anything in the archives.

Thanks for any help.


__________________________________________________________________________
Freeserve AnyTime - Go online whenever you want for just £6.99 a month for
your first 3 months, that's HALF PRICE! And then it's just £13.99 a month
after that.

For more information visit http://www.freeserve.com/time/ or call free on 
0800 970 8890