Which is best?

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

I have a form that I plan on using to maintain a table with matching fields.
I will also need to create a couple of reports from buttons on the form.

First, am I better off creating a query and using it for the record source
or should I use the table itself ? And why?

Second, what would be considered standard buttons for the form? (I know I
want one to print a report.) OK?, Quit?, Undo? suggestions.
thanks...
 
I have a form that I plan on using to maintain a table with matching fields.
I will also need to create a couple of reports from buttons on the form.

First, am I better off creating a query and using it for the record source
or should I use the table itself ? And why?
Click to expand...

Generally a Query, because a Query allows you to select which fields
to display, which subset of the records to display (e.g. just the
current year's records), and most particularly lets you specify a sort
order. You can do so on a Form as well but IME it's usually easiest to
base the Form on a sorted query.
Second, what would be considered standard buttons for the form? (I know I
want one to print a report.) OK?, Quit?, Undo? suggestions.
thanks...
Click to expand...

There are as many standards as there are developers... at a minimum.
 
1. I would use a query. You can sort easily in a query, you can limit the
records returned in a query.

2. Standard buttons? It all depends. A close button for the form is good. An
undo button is nice. A report button is nice in some cases.
 
Back
Top