New information added to table not showing in form

D

denilynn

I've added new client information into a table and it doesn't show up in the
corresponding form. Existing client information that was imported into the
table from Excel does show in the form however. What do I need to do?
 
A

Arvin Meyer [MVP]

Check the recordsource of the form to make sure it reads the entire table
and has no filter. Then try entering the data through the form. If it
doesn't show up in the table, you may need to build a better query as a
recordsource.
 
J

John W. Vinson

Define "Make sure the record source reads the entire table".

Open the Form in design view.
View its Properties.
On the Data tab select the Recordsource property (it's the first line).
If it's a Query click the ... icon by it to open it in query design view.

If you open the query as a datasheet do you see all the records you expect?
Does the query have any criteria or Joins which might limit which records
appear?
 

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

Top