Form now Sub-Form, Query Broken

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I recently posted this problem in "Forms" (Lost Focus of Form 7/27) thinking
that was the problem, but recently discovered the problem appears to be in
the query(ies).
I've dropped a from into a form that has multiple tabs/pages to consolidate
things. The other - now sub-forms still function as before, but this one
retrieves records from the archive and drops them in the the main employee
table.

The following pops up as an input box - Forms.Archive.track
I found this in one of the queries where:

Field: Track - its the unique identifier for the employee table
Table: Employee Data Table Archive
Sort:
Append To: Track
Criteria: [Forms].[Archive].[Track]

My new form with the multiple tabs/pages is called AdminTabForm and has a
tab called Archives which is where I had dropped the original "Archive" form.
How can I get this to work as it did before?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lost Focus of Form 1
Moving Subform to Tab Control 3
Subquery in Form 1
Add new records into source table on Form 8
Selecting a Value from a table in a form 6
Forms 1
Multiple Table values visible in controll box 2
Forms - Displaying Multiple Records in one form 3

Back
Top