Re: main form subform relationships

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 11/11/04 

Date: Wed, 10 Nov 2004 18:36:02 -0600

On Wed, 10 Nov 2004 15:34:03 -0800, Sammie 1960 wrote:

> When creating a subform does there have to be a one-to-many relationship
> with the main form or can subform be created without this relationship?
> If so, how?

If you leave the MasterLink and ChildLink properties blank then the
subform will show all of its records and it will not change as you
navigate in the main form. 

-- 
I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Relevant Pages

  • Re: Subform Problem
    ... subform but it looks "cleaner" going thru the command rather than ... Main form has as its RecordSource a single table or a query based on a single ... The MasterLink property is set to the name of a field in the main form's ...
    (microsoft.public.access.forms)
  • Re: Q. Please point me to a good tutorial on using form tabs control
    ... I want to use the tab ... > having it set the way it is, which is subform within subform. ... Basically you need the MasterLink property of the second subform to refer ... Alternatively you can have a hidden control on the parent form that grabs ...
    (microsoft.public.access.formscoding)
  • Re: Subform Not Responding
    ... Just use the TxtCoID as the MasterLink and the subforms matching field ... > I'm trying to get a subform to respond to the click of a dropdown on my ... The main from dropdown has the following code: ... > Private Sub ComboCoName_AfterUpdate ...
    (microsoft.public.access.formscoding)
  • Re: Cant see choices in Subform wizard
    ... So drop the wizard. ... Set the MasterLink and ChildLink properties on the subsequent subform ...
    (microsoft.public.access.forms)
  • Re: Main form saving when click on subform??? A97
    ... ChildLink properties have nothing to do with it. ... never select the subform control in my earlier versions of this app ... the entries onto the main form. ...
    (comp.databases.ms-access)