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
|
|||
|
|||
Automatically copying one value from one form to another form.
Database Background: When processing a record you have to enter information
into three seperate forms. I would like to create an automatic action, so that when you open the next form the same "Ref Number" from the previous form is entered into the new form and recorded in the table. I've tried the Look up Wizard but that only gives me a list and it is not shown on the new form. Any one know the solution |
#2
|
|||
|
|||
Cookie
Why? As in "why does the same information need to be entered in three separate forms?" And since forms generally reflect underlying data in tables, are you saying the same data is being entered in three different tables? If so, ?!why?! -- More info, please ... Jeff Boyce Access MVP "Cookie" wrote in message ... Database Background: When processing a record you have to enter information into three seperate forms. I would like to create an automatic action, so that when you open the next form the same "Ref Number" from the previous form is entered into the new form and recorded in the table. I've tried the Look up Wizard but that only gives me a list and it is not shown on the new form. Any one know the solution |
#3
|
|||
|
|||
The reason why the same information is being entered into the three seperate
forms is because the "Ref Number" is the primary key of the table and when exporting the data from Access to Excel this will be used to identify the data. The reason why there are three separate tables is beacause Access limits the amount of fields (255) per table. Another reason why i want the ref number to be automatically repeated on each of the three forms is so that who ever is inputting the data won't have to key in the ref number repeatedly to reduce the likely hood of error. Thanks "Jeff Boyce" wrote: Cookie Why? As in "why does the same information need to be entered in three separate forms?" And since forms generally reflect underlying data in tables, are you saying the same data is being entered in three different tables? If so, ?!why?! -- More info, please ... Jeff Boyce Access MVP "Cookie" wrote in message ... Database Background: When processing a record you have to enter information into three seperate forms. I would like to create an automatic action, so that when you open the next form the same "Ref Number" from the previous form is entered into the new form and recorded in the table. I've tried the Look up Wizard but that only gives me a list and it is not shown on the new form. Any one know the solution |
#4
|
|||
|
|||
On Mon, 4 Apr 2005 06:11:03 -0700, Cookie
wrote: The reason why the same information is being entered into the three seperate forms is because the "Ref Number" is the primary key of the table and when exporting the data from Access to Excel this will be used to identify the data. The reason why there are three separate tables is beacause Access limits the amount of fields (255) per table. I've needed as many as 60 fields in a table... once, in the past 20 years of database development. 255 fields is absurdly large; 750 fields is simply *not a database*. You would do MUCH MUCH better to properly normalize your data, and extract the one-to-many relationships embedded within each record in this monster into separate tables! You can recast the data into "wide-flat" format for export to Excel, but there is NO reason I can imagine why you should store the data in this way. "Fields are expensive, records are cheap"! Another reason why i want the ref number to be automatically repeated on each of the three forms is so that who ever is inputting the data won't have to key in the ref number repeatedly to reduce the likely hood of error. If you *really* insist on working with this incorrect data structure, you can use a Form for the first table, with two Subforms for the second and third. Use the Ref Number as the master/child link field. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to clear controls of Filter form | Jan Il | Using Forms | 2 | November 28th, 2004 02:04 PM |
open a form through a subform in access 2000 | Tammy | Setting Up & Running Reports | 12 | October 22nd, 2004 02:43 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |