C
Chris
i have created some forms based off tables. Is this wrong or should the forms
be based off queries.
be based off queries.
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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.
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???
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.
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.
R
Rockn
Forms should be based off of the function they are meant to perform.
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.
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.
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?
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.
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.
Forms are based on data using either a table or a query. They are designed
to provide some business functionality.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.