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.

--
Jim

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200612/1

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.

chopper57 wrote:
>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.
>

--
Jim

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200612/1