table/form

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

Guest

I'm adding rows in my form: just adding up different characteristics
for
listing them up in the merge report. But when i rearrange the rows in my
table it's not reflected in the form: it's still the same old table
arrangement. The form doesn't see my new table.
I can sort records, or change data in them, only in the table. In the
form window I can highlight rows whatever is appropriate for each client and
then press 'add' button (that's how I'm adding them up for each client).
In the form, under the window, there are names of clients. I press on
the client i'm interested in, then highlight some rows in the window, then on
'add' button, then i see all highlighted information appear in the field
corresponding to
this client under the window.
As i said before my new resorted table which is supposed to appear in
the form window, is not seen there. Let me explain again:
I can see my table in the form window where i can highlight different rows.
Then these highlighted rows go into a detail line, where there are: id#,name,
(it's already populated when i open the form with all the clients i have in
my query) and a 'characterictic' field - it's empty and that's where i
put/add highlighted rows from the window(table) in the form. I highlight
these rows myself according to what is known about these clients. When I go
to my original table and make some small changes, somehow I don't see them in
the form window, what I see is the old table content.
I'd appreciate some help.
Thanks
Alex.
 
Alex1,
Good Day,
Your post is very long. Even you did try to make more cleare your problem
but your clarification made it more complicated.
Anyhow, Once you have create your form. then you have to pic fields from
Table/Quary and have to add in your form. Auto addtion happening only first
time when you creat you form.

Have a nice use of Access.
 
Hi,
Thanks for reply. I just want to see in my form's window the rows to be
sorted in the same order as in my table. How can I do it?
Alex.
 
Alex1,
Good Day,
I did not understand why you are making your work complicated?
Sorting normally required for the columns not for rows.
Your fields in form will be entirely different and flexible as you are
having with your table.
In froms you are not bound to keep them as it is.
Work hard to understand more and more about forms then rise your questions.

Regards,
 
By definition, records in relational tables are _unordered_. You cannot rely
on them being retrieved in any particular order unless you do as relational
design requires and order them in a retrieval query... in the Query Builder
you click Ascending or Descending in the Sort line beneath the Field Name
line. In SQL view, you include an ORDER BY clause.

That is the reliable way to order or reorder records in a form.

The order in which records are presented in a report is controlled by the
report's sorting and grouping properties -- if anyone has the proper order
in a report without specifying sorting and grouping, he/she was just lucky.

Larry Linson
Microsoft Access MVP
 
Back
Top