Query doesn't return new records

G

Guest

I have set up a query that has several tables associated. (All the tables are
linked)
tblProjects - pulls basic project information
tblBAIRCV - pulls option group value description (based on option group
found on frmProjects)
tblT&MLSNTE - same as BAIRCV
tblJobStatus - same as BAIRCV
tblBillStatus - same as BAIRCV
tblCustomers - Pulls Customer name based on Lookup field from tblProjects
tblProjectManager - Pulls PM Name based on Lookup field from tblProjects
tblEmployee - Pull Employee Name based on Lookup field from tblProjects

There are several parameters set that allow the query to filter info based
on form entries or to retrieve all records when the form is left blank.

Currently the query will return information for every record that was
already entered before I started building the query but won't return data for
any new records that are created.

I don't know why it won't retrieve the new records, it does retrieve updated
info on the records that were previously created.

I would appreciate any help to get it to retrieve all records not just the
old ones.

Thanks.
 
J

Jeff Boyce

Without a look at the query (SQL), it's gonna be tough guessing why it
doesn't return what you want...

More info, please...

Jeff Boyce
<Access MVP>
 
V

Van T. Dinh

I am not sure of the clause "any new records that are created" but Queries
can only retrieve Records that have been committed into the Table, not
NewRecord that shows on the Form but not yet saved / updated into the
Table(s).
 

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


Top