Question Query not showing latest results

[mara]

I have created a database for a company that shows all the information from when one of their sites is updated. I have done this by a means of four tables,

being site info > site code > reports code > report

I have a query that I use as a search by someone inputing a word or code into a blank textbox and a form appears showing the records, it searches for specific information that can be found in both the site info table (which has addresses, names ect) The site code form (which just displays the unique code alphanumeric code given to the site in a drop down box on my form) and from the report itself which shows what has been changes by referencing to different file numbers.

Up untill lunch time today the query has been working fine.

Although now it wont show the latest records I have entered so I am unsure how to proceed. The information is still there in my tables and the query has been showing all the newer records prior.

This happened initially when I created the database resulting in making a new query, (exactly the same) which is too time consuming to do everytime.

Does anyone have an idea what is happening?

THANKYOU

 

[jdraw]

Can you show us some table and query structures? We can only guess until you show us what you are trying to do and the code involved.

 

[mara]

I am not to sure how to show this?

I think I may have figured out the cause,
The form I has has the Site code ID as the form and then the report details as the subform.

I have a drop down list for the Site Code ID and when you type in the code manually and click enter, the result appears on the in the query. However if you use the drop down list, and select the result, it then doesn't register in the query.

Is there away to overcome that or is it some sort of bug? I can't exactly tell users not to use the drop down box, which sometimes is the way you have to find a site.

 

[BBQ Kittens]

Like jdraw said, without seeing your structure its all guessing, you can post this through 'post reply', though i believe you need 10 posts on the forums before you may do that?