ODBC LINK giving error with filter

[Gaetanm via AccessMonster.com]

Hope someone can help. I’m not to sure where to post this. Forms, linking ,
ODBC

I have a main form with subform.

Main form has:
Combo box [cboJobid]which is filled with a query. Combo is Numeric.
Text field [Jobid_txt]looks at combo and takes in the number as Text.

[Subform1] is ODBC link driven by query.

The child is [JobNumber] which is text
The Master is [Jobid_txt]

When I do the child / master I get an ambiguous message:
“Microsoft office Access has encountered a problem and needs to close… “

When I erase the filter of Child /Master I do not get the error but I do get
all the records which is normal.

I decided to delete my links and I IMPORTED the tables instead

The form works like a charm .

I would like to LINK if that is not possible How can I create a button on my
form that would Delete the existing Imported tables and Import the updated
ones.

Any suggestions would greatly be appreciated

Thanks
Gaetanm

 

[d]

Hope someone can help. I'm not to sure where to post this. Forms, linking ,
ODBC

I have a main form with subform.

Main form has:
Combo box [cboJobid]which is filled with a query. Combo is Numeric.
Text field [Jobid_txt]looks at combo and takes in the number as Text.

[Subform1] is ODBC link driven by query.

The child is [JobNumber] which is text
The Master is [Jobid_txt]

When I do the child / master I get an ambiguous message:
"Microsoft officeAccess has encountered a problemand needs to close... "

When I erase the filter of Child /Master I do not get the error but I do get
all the records which is normal.

I decided to delete my links and I IMPORTED the tables instead

The form works like a charm .

I would like to LINK if that is not possible How can I create a button on my
form that would Delete the existing Imported tables and Import the updated
ones.

Any suggestions would greatly be appreciated

Thanks
Gaetanm

Check http://allenbrowne.com/ser-25.html on Allen Browne's web site.
"In your subforms, include a text box for each field in its
LinkChildFields property. This simple step avoids frequent of Access
2002 and 2003 ("... shut down by Windows..."), where the form is based
on a query (not directly on a table.) The text boxes can be hidden if
you do not wish to see the foreign key fields."

 

[Gaetanm via AccessMonster.com]

Thank you for your help in getting me in the right direction

Gaetanm

Hope someone can help. I'm not to sure where to post this. Forms, linking ,
ODBC

[quoted text clipped - 31 lines]
Check http://allenbrowne.com/ser-25.html on Allen Browne's web site.
"In your subforms, include a text box for each field in its
LinkChildFields property. This simple step avoids frequent of Access
2002 and 2003 ("... shut down by Windows..."), where the form is based
on a query (not directly on a table.) The text boxes can be hidden if
you do not wish to see the foreign key fields."