forms based off queries

C

Chris

i have created some forms based off tables. Is this wrong or should the forms
be based off queries.
 
D

Douglas J. Steele

There's nothing wrong per se, but by using a query you can be certain of the
order in which the records will appear on the form.
 
C

Chris

can you explain what you mean by order.. do you mean filtering, sorting,
orformatting order???
 
D

Douglas J. Steele

I was referring to sorting.

While forms do have an OrderBy property, as well as a Filter property, I
find it much simpler to use a query that sorts and filters the records.
 
C

Chris

thk u

Douglas J. Steele said:
I was referring to sorting.

While forms do have an OrderBy property, as well as a Filter property, I
find it much simpler to use a query that sorts and filters the records.
Click to expand...
 
D

Douglas J. Steele

What's that supposed to mean? It doesn't seem relevant to the question.

There's really no fundamental difference between a table and a query based
on that same table. Both point to the same entity.
 
R

Rockn

The initial question was related to forms and basing them off of tables or
queries. Personally I would never design a form based on a table or a query,
but the function the form was meant to perform. make sense now?
 
B

Beetle

You misunderstood the original question.

When the OP asked if a form should be "based off a table or query", they are
talking about the RecordSource of the form, not the design of the form. The
RecordSource has very little to do with the actual design/UI of the form.
 
K

Klatuu

Sorry, it makes absolutely no sense.
Forms are based on data using either a table or a query. They are designed
to provide some business functionality.
 
Top