Detail Section not showing after splitting database

[cp2599]

I have a form whose record source is a query that joins two tables.
The form is used to add information to two tables at the same time.
It works fine in a database where the tables reside with the form, but
the detail is blank with the split database. When executing the query
in the split database no new record appears. When executing the query
in the non-split database, a new record appears. Does anyone know why
or have any suggestions on what I need to do?

 

[cp2599]

I have a form whose record source is a query that joins two tables.
The form is used to add information to two tables at the same time.
It works fine in a database where the tables reside with the form, but
the detail is blank with the split database.  When executing the query
in the split database no new record appears.  When executing the query
in the non-split database, a new record appears.  Does anyone know why
or have any suggestions on what I need to do?

I discovered that the FROM statement in the query that doesn't work
was not correct. Sorry for the too quick of a post.