Subform Problem

[Chigger Hill]

I have a form sourced from a linked table. I entered a subform sourced from
the database using the wizzard. Everthing works great until I put data in
the subform. When I attempt to open the database or advance to a new record,
I get an error message that the expression is too complex and that I cannot
open the database. I click OK and the form opens without the subform. I do
not work in SQL or code. Can anyone help me?

 

[Golfinray]

Start by making sure you got the Mainform and subform linked properly. They
will usually link on something in common to both, like an ID number. The
wizard should have asked you what you wanted to link on. Try deleting the
subform and using the wizard again and have it link for you if there is a
problem.

 

[John W. Vinson/MVP]

I have a form sourced from a linked table. I entered a subform sourced from
the database using the wizzard. Everthing works great until I put data in
the subform. When I attempt to open the database or advance to a new record,
I get an error message that the expression is too complex and that I cannot
open the database. I click OK and the form opens without the subform. I do
not work in SQL or code. Can anyone help me?

Not without some SQL. :-{(

We can't see your database or your form. Please open the subform in
design view. View its Properties, and find the Recordsource property.
What's there? A table name? or a query? If it's a query, copy and
paste it (the SQL view of the query) to a message here.

 

[Chigger Hill]

The subform is from a table called Training Header. I have replaced the
subform many times. There are no queries in the database yet.

 

[John W. Vinson/MVP]

The subform is from a table called Training Header. I have replaced the
subform many times. There are no queries in the database yet.

What are the names of your tables, and the relevant fields in the
table? It's possible that you have some punctuation or blanks or other
legal-but-unwise characters in the fieldnames which are causing Access
to choke.

 

[Chigger Hill]

One table is very large from a commercially developed Access program that
works well in that database and I have linked it to other databases. The
other table has four fields: Record ID (autonumber), Employee ID (Number
that relationship is based on), Training Completed (text), Date Completed
(Short Date), Due Again (Short date), and comments (Memo).

I changed the Employee to a text field and everything is ok now. Thanks for
the question that put me to thinking.