If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
from table to form
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. What can be done? I'd appreciate some help. |
#2
|
|||
|
|||
if you're talking about *sorting* records, don't do it at the table level.
sort the records directly in the form, or sort them in a query and bind the query to the form. hth "alex1" wrote in message ... 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. What can be done? I'd appreciate some help. |
#3
|
|||
|
|||
Thnks, Tina. I can't sort records anywhere except 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 table arrangement is not seen in the form. "tina" wrote: if you're talking about *sorting* records, don't do it at the table level. sort the records directly in the form, or sort them in a query and bind the query to the form. hth "alex1" wrote in message ... 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. What can be done? I'd appreciate some help. |
#4
|
|||
|
|||
alex1 wrote:
Thnks, Tina. I can't sort records anywhere except 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 table arrangement is not seen in the form. Sorry, but none of that makes any sense to me at all. What is "under the window"? What do you mean "I press on the client I'm interested it"? What is this "add button"? What do you mean by "table arrangement"? If by "table arrangement" you mean that you have altered the design by adding new fields then those new fields "might" automatically show up in your form's list of available fields. If the form is bound to a query that explicitly picks certain fields from the table though (typical if built with the wizard) then you will need to modify that query to add the new fields to it. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
Combo Box NotInList - How To Add Data To Underlying Table | 10SNUT | Using Forms | 19 | July 8th, 2005 09:12 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Get data from combo box to popluate the next box | Lin Light | Using Forms | 4 | December 30th, 2004 05:01 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |