new info added on a form not showing up in search but is in table

[cduffy]

I am self-taught in Access, and I do not do code. I created an Access 2003 database several years ago that our office uses for all information about children being referred, evaluated and served by our program. It has just one table with at least 150 columns. Information on each child is viewed through the forms only and more information is added to each file throughout the eligibility process.

We all received new computers with Office 2010 this year and I wanted to update the database to the new version. I have just recreated it in 2010 by importing all the data into three related tables and recreating the forms to input the data. I can see the data in the forms and can add new info, however when I search for newly inputted data it tells me the search item was not found. But when I open the table, it is there. Why will the form not pull up the new info?



Please help, I am on a very limited time frame to get this up and running for our staff!! Thanks!!

[RuralGuy]

With such little information to go on, all I can suggest is the "new info" has not been saved yet. Maybe if you gave us more details about your process we could offer better suggestions.

[cduffy]

I did save it, however I have never had to save before. It still isn't showing up. Would it help to look at my DB?

[RuralGuy]

Almost certainly if you could provide it. Compact and Repair first then zip it up to attach to a post.

[cduffy]

I tried attaching it but even zipped and with only two files in it, it is still 2.27 mb and won't attach. Now what?

[RuralGuy]

I'll send you a PM.

[RuralGuy]

We took this thread off line and solved it. The main issue was the dynamic query of the form was limiting the selection. We created a static query that did not have the limit and then set it as the RecordSource of the form. The search then started to function as expected.