Connecting Tech Pros Worldwide Help | Site Map

Auto-fill Subform Reference

  #1  
Old July 2nd, 2008, 09:15 PM
z.ghulam@gmail.com
Guest
 
Posts: n/a
Hi,

I have a subform in a main form.
When I create new records in the subform I would like the Subform.
[Issue Ref] to autofill with the MainForm.[Ref]
It sounds quite simple, but ive been bustin my brains trying to get it
to work with no success.

Any help would be greatly appreciated.

Cheers
  #2  
Old July 3rd, 2008, 05:55 AM
Tom van Stiphout
Guest
 
Posts: n/a

re: Auto-fill Subform Reference


On Wed, 2 Jul 2008 13:12:21 -0700 (PDT), z.ghulam@gmail.com wrote:

Check out LinkChildFields and LinkMasterFields in the help file. Set
these properties and that behavior is automatic. If you drop a subform
on a form while the control wizard is on, it will help you set the
values.

-Tom.

Quote:
>Hi,
>
>I have a subform in a main form.
>When I create new records in the subform I would like the Subform.
>[Issue Ref] to autofill with the MainForm.[Ref]
>It sounds quite simple, but ive been bustin my brains trying to get it
>to work with no success.
>
>Any help would be greatly appreciated.
>
>Cheers
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Subforms - Passing in form values to a query robtyketto answers 2 February 20th, 2008 12:41 AM
How to have two subforms on one main form reference same table?? tlyczko answers 3 February 16th, 2006 10:15 PM
Want my subform info to autopopulate... Fork_In_Road answers 2 November 12th, 2005 10:44 PM
Want my subform info to autopopulate... Fork_In_Road answers 2 November 12th, 2005 10:17 PM
NOT IN(SELECT Jos? answers 14 November 12th, 2005 06:30 PM