Forms question

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

Guest

When I type information into a form, everything works perfectly; the
information is stored in the tables and I can use the search function to call
up records that I type in if I want. The problem is that when I close the
form and reopen it, it starts over with record 1 and when I try and search
for a record that I had previously typed in, it cant find it. Can someone
explain what the problem is? It was my understanding that you could search
through the database using a form.
 
You may be opening the form in Add mode. If that's the case, no historic
records will be visible or searchable. Open the form in Edit mode to view all
records. You can switch to edit mode by right-clicking on the form and
choosing "Remove Filter/Sort".

A quick method that can be used for searches is the Filter By Form or Filter
By Selection options. Right-click on the form to see these choices.
 
When I type information into a form, everything works perfectly; the
information is stored in the tables and I can use the search function to call
up records that I type in if I want. The problem is that when I close the
form and reopen it, it starts over with record 1 and when I try and search
for a record that I had previously typed in, it cant find it. Can someone
explain what the problem is? It was my understanding that you could search
through the database using a form.
Click to expand...

In addition to rowiga's suggestions, open the Form in design mode and
check to be sure that the "Data Entry" property of the form is set to
No. If it's Yes, you'll be able to add new records but not to view old
ones.

John W. Vinson[MVP]
 
Back
Top