ODBC LINK giving error with filter

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200705/1

.

Quantcast