flipping problem in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When putting data into a form when you look at it on the screen the line
items are in the right order. Then when you go to print out the report the
line item are in the wrong order. What can we do to stop this from happining.
please advise
 
Open the report in design view.
Open the Sorting and Grouping dialog (View menu.)
Enter the fields that define the sort order.

For example if your form has an AutoNumber primary key, the form will sort
on this field. Enter its name into the dialog, and the report sill sort on
this field also.
 
Thanks for the help on the report. This helped on the report. But how hoe do
I keep it form flipping on the form its self. Please advise if there is a
way to fix this.
thanks
 
To specify the sort-order in a form, create a query and use the Sorting row
to specify which field(s) it should sort by. Save the query. Open the form
in design view, and set its RecordSource to this query.

If the autonumber field is primary key in your table and the form is just
drawing records from one table, I would expect Access to retrieve the
records in the order of the primary key field even without the query. You
might like to open your table in design view, and check that this field is
marked as the primary key of your table.
 
The form is a data entry form, so the user must enter data. If you set the
recordsource to the query then it will no longer accept input from the user.
Once the user types data into the form, it is stored directly into the table.
The user is actually typing data into a subform located on a main form.
Sometimes the data in the subform re-sorts itself and sometimes it doesn't.
When the data re-sorts, it is never all the rows in the subform, only one or
two. The data does not re-sort until the user closes the form and re-opens
it. It is very random, so it does not happen all the time, only sometimes.
Is this a bug in the design or is it an access bug? I tried setting an Order
By in the table the data is stored in, but that didn't do anything to the
form order. Any other suggestions would be appreciated. Thanks.
 
While some queries are read-only, using a query does not necessarily make it
read-only. You should have no problem with a single-table query.

The records in the subform will stay in the order the user entered them
until the subform is requeried or reloaded.
 
Back
Top