Only one record shows in input form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mary Hartman - 18 Nov 2007 21:26 GMT

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!!

:>)

Reply to this Message

Bob Quintal - 18 Nov 2007 22:56 GMT

> Good morning,
>
[quoted text clipped - 15 lines]
>
>:>)

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.

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

jrmask - 18 Nov 2007 23:55 GMT

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

>Good morning,
>
[quoted text clipped - 15 lines]
>
>:>)

Signature

Richard Mask

Reply to this Message