forms based off queries

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

i have created some forms based off tables. Is this wrong or should the forms
be based off queries.
 
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.
 
can you explain what you mean by order.. do you mean filtering, sorting,
orformatting order???
 
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.
 
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...
 
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.
 
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?
 
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.
 
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.
 
Back
Top