Which is better? To run a form from a query or from a table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

andreainpanama - 05 Jul 2006 22:58 GMT

And a connected question...

Right now, my form is storing it's info in tables, even though it-s record
source is a query. And the form only shows me one blank each time I start
up. But if I change the source to a table, then the form let's me see each
form page, in the order I entered it. Which is what I want...but it doesn-t
do this when it is connected to the query.

Other than that...everything-s just fine and dandy!

Reply to this Message

Douglas J. Steele - 05 Jul 2006 23:37 GMT

If the order of records in the form is important, then you really must use a
query. You can never assume anything about the order of records in a table:
the only way to ensure the correct sequence is a query with an ORDER BY
clause.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> And a connected question...
>
[quoted text clipped - 7 lines]
>
> Other than that...everything-s just fine and dandy!

Reply to this Message

Ron2006 - 06 Jul 2006 17:58 GMT

The reason you are seeing only one form (entry) is that you have a
"yes" in the dataentry property of the Properties Data Tab. A yes in
that position says open up in an add mode.

OR

If you are calling it from the standard meny you said to open it in ADD
mode and not edit mode.

Either

Take the Yes off of the dataEntry property
or
change the call to an edit mode.

Ron

Reply to this Message

andreainpanama - 07 Jul 2006 22:20 GMT

Actually, there was a "no" in the data entry tab.

I didn't understand your second suggestion "calling" it from the standard
menu. Huh?

I would like to be able to see all my records in the prettily designed form
format (in addition to running reports off the query or viewing it as a
table.)

Thanks so much!

> The reason you are seeing only one form (entry) is that you have a
> "yes" in the dataentry property of the Properties Data Tab. A yes in
[quoted text clipped - 12 lines]
>
> Ron

Reply to this Message

Ron2006 - 10 Jul 2006 13:48 GMT

Ok, the first possibility is eleminated then.

On the second possible cause:
The question is:
Are you using the standard switchboard that you can sort of
automatically set up in Access. If you are using that switchboard, one
of the questions it asks when you say you want to open a form is.
Do you want to open the form to edit records or to Add records. If you
say Add then the form will be opened in an add mode and previously
entered records WILL NOT be visible.
What it does not tell you is that if you open the form in Edit mode you
can see the previous records AND add new records.

Are you using the standard Access switchboard?

Ron

Reply to this Message