Imported data in table not shown in Forms

[Zildjyn]

I added about 150 new records to my table but the new records are not showing up in the form that is linked. Am I missing something?

I have two tables:
ShoppersTable and MoreInfo

I have one form: Shoppers
The new records were added to ShoppersTable

The form is not showing the additional records.

Thank you very much in advance for any help.

[Robeen]

Can you post your database here?

[Zildjyn]

Thank you very much

[Robeen]

Your Shoppers Form is getting data based on this SQL which you can see if you:
1. Open the Form in design mode,
2. Open the Property Sheet and
3. Look at the 'Record Source' property.

 
SELECT Shoppers.ID, Shoppers.First, Shoppers.Last, Shoppers.Email, Shoppers.Address1, Shoppers.Address2, Shoppers.City, Shoppers.State, 
Shoppers.Zipcode, Shoppers.Phone, Shoppers.Fax, Shoppers.SSN, Shoppers.Gender, Shoppers.[Age Group], 
Sheet1.Experience, Sheet1.[Shop Types], Sheet1.Years, Sheet1.[Call Time], Sheet1.[Metro Area], Shoppers.Distance, Sheet1.Glasses, Sheet1.Camera, 
Sheet1.Clubs, Sheet1.HipHop, Sheet1.[Music Type], Sheet1.Type, Sheet1.Activities 
FROM Sheet1 INNER JOIN Shoppers ON Sheet1.ID = Shoppers.ID;

If you paste that SQL into a new Query in SQL View and run it - you will only get 68 rows of data.

This is because the join in your query is saying 'only give me records in which the ID in both tables match'.

Since the only common IDs in both tables are IDs 1 - 68 - that is all the query will return.

And that is what your Form is displaying.

What do you want your Form to display?

[Zildjyn]

I just want the form to update when new records are added to the tables. I usually add records to the form directly, but I just received a list of about 150 new shoppers and thought it would be easier to add them to the table. Wrong again.
Can this be done?

[Robeen]

Typically - there is never a problem with a Form displaying any new data that comes in to a Table.

But your Form is not based on one Table.

It is based on the SQL that is in the Record Source property of your Form.
And that SQL is limiting what the Form displays because of the Inner Join.

Does ONE of your tables contain ALL the data that you need your Form to display?
If there IS one Table that has ALL your data, then you can try making a copy of your current Form and then - in the copy - changing the Record Source property to that table - using the Drop Down arrow in the Record Source field of the Propery Sheet and selecting that Table.

Then - whatever you put in that table will automatically show when you run the form.

Let me know if this works!

[Zildjyn]

Is there any way I could merge the two tables?

[Zildjyn]

I merged the two tables into one but now how do I get my form to recognize the table again?

I've attached the screenshot.

[Robeen]

I don't know your data well enough so I can't advise on merging the data.

I know that the two tables have very different fields so they don't automatically fit into the category of tables that I would say could be easily merged.

If you could see a way to getting all the data into one Table, that would certainly make your task easier.

I think what you should do is try and create a query that will return all the data that you want your Form to display.
Is that a possibility for you?

[Robeen]

How did you merge the two tables?
What that message is saying is that the query behind your Form is no longer valid.
Did you change the names or design of either or both of the Tables?