Datasheet shows on enter

[chopper57 via AccessMonster.com]

I have a MainForm with a SubForm
The SubForm has two other subforms - datasheets
The two datasheets are linked, the first datasheet has a combo to select a
compnay
the second datasheet has a combo for employees.

The link is working I can add a company then add the employees.
the problem is in the employee datasheet, it only shows the employee if you
click in a field, it should show the employees related to the company when a
company name has focus.

I made mine by following the sample form from Access 2000 Developer's
Handbook. The sample database from the book has a date and menu items and
works instantly and has no special code.
I'm using Access 2003.

Any ideals why mines not working like the sample. I think it maybe because I
have another level of forms where the sample has only one mainform and two
datasheets subs.

 

[chopper57 via AccessMonster.com]

Update, problem fixed
Found a post that explained about the text box and binding it to the ID field
of the second datasheet form, it's working good.