Only one record shows in input form

M

Mary Hartman

Good morning,

I have created a database with Access 2003.

I imported 17 records from Excel into the products table.

When I open the input form to add new or correct the existing records,
the input form sees only one of the 17 records.

Can someone tell me why?

If it will help to look at the database, I have uploaded it to:
http://www.netstore02.com/db/

It is titled "trouble.mdb"

Thank you for whatever help you can give me!!

:>)
 
B

Bob Quintal

Good morning,

I have created a database with Access 2003.

I imported 17 records from Excel into the products table.

When I open the input form to add new or correct the existing
records, the input form sees only one of the 17 records.

Can someone tell me why?

If it will help to look at the database, I have uploaded it to:
http://www.netstore02.com/db/

It is titled "trouble.mdb"

Thank you for whatever help you can give me!!

:>)
Click to expand...
Sounds like your form's Default View property is set to Single form,
not Continuous Forms.

Open the form in design view, and if the properties dialog box is
not visible, press F4, click the Format tab and set the property.
 
J

jrmask via AccessMonster.com

It's your join in the query that's limiting you to one. Delete the join and
it will return all products.
 
Top