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
|
|||
|
|||
automatic fill in
We have a form with two subforms, and in the subforms we
have the same field called "box name." If we enter information on the first subform we want the same information to go into the second subform. Thanks! |
#2
|
|||
|
|||
automatic fill in
put the code in the first subform, in BoxName's AfterUpdate event, as
Me.Parent!SecondSubformCONTROLName!BoxName = Me!BoxName make sure you use the subform CONTROL name, rather than the name of the subform. to get the right name, open the main form in design view. click once on the 2nd subform *in the main form*, to select it. in the Properties box, click the Other tab, and look at the Name property. hth "Dave B" wrote in message ... We have a form with two subforms, and in the subforms we have the same field called "box name." If we enter information on the first subform we want the same information to go into the second subform. Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto fill criteria/questions on filling formulas down | JAnderson | General Discussion | 2 | July 19th, 2004 09:45 PM |
Vlookup value from fill colour only. | shital | Worksheet Functions | 1 | June 7th, 2004 02:34 PM |
Object defaults (e.g., default fill color) | Jeff | Powerpoint | 2 | June 5th, 2004 03:56 AM |
FILL A RANGE OF NUMBERS | Max | Worksheet Functions | 1 | November 7th, 2003 11:39 PM |