Records showing twice in Form and new records not showing at all

[DCscauk]

Hi Hope somebody can help me as I have been trying to figure this problem out for the last 5 hours with no luck.

I have a form created from 1 table. When I look at the form it has duplicated all of my table records so they all appear twice.

Also my any new data I enter on my form is populated in my table but doesn't show up in the form once I have moved away from that record.

I am sure I am just doing something stupid but it is driving me mad...

Please lovely people help!!!

[RuralGuy]

A Form has a RecordSource. Open that RecordSource directly as a query and see what is going on.

[DCscauk]

The record source looks fine :
SELECT [DATA TABLE].ID, [DATA TABLE].[DB Number], [DATA TABLE].Tag, [DATA TABLE].MPN, [DATA TABLE].Title, [DATA TABLE].[Description English - MAX 50 COMMA], [DATA TABLE].NOTES, [DATA TABLE].[Main EAN], [DATA TABLE].Colour, [DATA TABLE].Type, [DATA TABLE].[Page Yield], [DATA TABLE].[SKU 2], [DATA TABLE].[SKU 3], [DATA TABLE].[SKU 4], [DATA TABLE].[SKU 5], [DATA TABLE].[SKU 6], [DATA TABLE].[SKU 7], [DATA TABLE].[SKU 8], [DATA TABLE].[SKU 9], [DATA TABLE].[SKU 10], [DATA TABLE].[EAN 2], [DATA TABLE].[EAN 3], [DATA TABLE].[EAN 4], [DATA TABLE].[EAN 5], [DATA TABLE].[EAN 6], [DATA TABLE].[Search Field 1], [DATA TABLE].[Search Field 2], [DATA TABLE].[Search Field 3], [DATA TABLE].[Search Field 4], [DATA TABLE].[Main EAN], [DATA TABLE].[Picture File], [DATA TABLE].[Compatible Printers], [DATA TABLE].[Compatible Printers 2], [DATA TABLE].[Compatible Printers 3], [DATA TABLE].[Compatible Printers 4], [DATA TABLE].[Compatible Printers 5], [DATA TABLE].[Compatible Printers 6], [DATA TABLE].[Compatible Printers 7], [DATA TABLE].[Compatible Printers 8], [DATA TABLE].[Compatible Printers 9], [DATA TABLE].[Compatible Printers 10], [DATA TABLE].[Compatible Printers 11], [DATA TABLE].[Compatible Printers 12], [DATA TABLE].[Compatible Printers 13], [DATA TABLE].[Compatible Printers 14], [DATA TABLE].[Compatible Printers 15], [DATA TABLE].[Compatible Printers 16], [DATA TABLE].[Compatible Printers 17], [DATA TABLE].[For Translation], [DATA TABLE].[Original / Compatible], [DATA TABLE].Manufacturer, [DATA TABLE].PictureURL, [DATA TABLE].[PictureURL 2], [DATA TABLE].[PictureURL 3], [DATA TABLE].[PictureURL 4], [DATA TABLE].[AMazon FR Price], [DATA TABLE].[SKU FR], [DATA TABLE].Yield, [DATA TABLE].[DC EAN], [AMan Pro].Cost, [AMan Pro].MinPrice, [AMan Pro].MaxPrice, [DATA TABLE].[Amazon DE Price], [DATA TABLE].[SKU DE], [DATA TABLE].ID1, [DATA TABLE].[Multiple Man], [DATA TABLE].[Compatible Printers 18], [DATA TABLE].[Compatible Printers 19], [DATA TABLE].[Compatible Printers 20], [DATA TABLE].[Compatible Printers 21], [DATA TABLE].[Compatible Printers 22], [DATA TABLE].[Compatible Printers 23], [DATA TABLE].[Compatible Printers 24], [DATA TABLE].[Compatible Printers 25], [DATA TABLE].[Compatible Printers 26], [DATA TABLE].[Compatible Printers 27], [DATA TABLE].[Compatible Printers 28], [DATA TABLE].[Compatible Printers 29], [DATA TABLE].[Compatible Printers 30], [DATA TABLE].[Compatible Printers 31], [DATA TABLE].[Compatible Printers 32], [DATA TABLE].[Our German Price], [DATA TABLE].[Our French Price], [DATA TABLE].[Series 1], [DATA TABLE].[Series 2], [DATA TABLE].[Series 3], [DATA TABLE].[Series 4], [DATA TABLE].[Series 5], [DATA TABLE].[Series 6], [DATA TABLE].[Series 7], [DATA TABLE].[Series 8], [DATA TABLE].[Series 9], [DATA TABLE].[Series 10]
FROM [AMan Pro] INNER JOIN [DATA TABLE] ON [AMan Pro].SKU = [DATA TABLE].SKU;

[RuralGuy]

Does the SKY appear more than once in the [AMan Pro] table? You also need to study up on Normalization.

[DCscauk]

I assume you mean SKU .. and the answer is no :-(

Am going to read up on it now.. thanks for any help you can give...

[RuralGuy]

Yes, SKU. You have several repeating fields which should probably be in a different table of their own. Try simplifying your query to one or two fields in the [DATA TABLE] table and see what happens in the query.