finding specific form

[smiller]

I am inputing data into a form and then printing that sheet from the form directly. It is working great for that as long as I input the data and print the form immediately. The trouble comes though when I am trying to find the specific form sheet again to either make changes to it or to check something on it. In the beginning, I used the ID number to locate a form by the bottom index used for scrolling through all the individual sheets. As time as progressed though the ID number and index no longer match up. It makes it near impossible to locate any old form sheet. Any suggestions?? Thanks

 

[lightray]

How many records/sheets are we talking about? Is it worth editing the table?
or are you looking for a lookup function?

 

[smiller]

right now there are over 900 entries and that number will just increase as time goes on. What I was thinking would be best is something that searches for the ID number (i think i made something that does this already) and then I can input that ID somewhere in the form sheet to locate the specific form. Do you know how I could do this or do you have any other suggestions? I am really open to anything.

 

[ansentry]

You can put a combo box in the header of the form that will GoTo the record selected.

To do this use the Wizard, you will see the 3rd option, use that.