Re: Sub forms

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 01/05/05 

Date: Tue, 04 Jan 2005 19:16:01 -0700

On Tue, 4 Jan 2005 12:27:04 -0800, "Mattymoo"
<Mattymoo@discussions.microsoft.com> wrote:

>Thank you for your help. Makes sense, but when I go to link the pending
>subform via the master field to the claim ref text box, it's not there as an
>option - all I get are the client details.

It's not there as an option - but it works if you explicitly type in
the name of the combo box.

                  John W. Vinson[MVP]

Relevant Pages

  • How do I stop a subform from repeating records?
    ... A very important subform is repeating records. ... The child field is a primary key with up to 15 characters, ... first 10 being identicle to the master field. ...
    (microsoft.public.access.forms)
  • Form with multiple attached items
    ... I have a main form in which client details are recorded, ... I would fill out my client details and then within the subform I ... that the "master" details recognise each ... Access only wants to associate the first product line with those ...
    (microsoft.public.access.formscoding)
  • Re: Sub forms
    ... but when I go to link the pending ... subform via the master field to the claim ref text box, ... now set the Link Child Fields property of the Pending subform to ... > current Claim record on the Claim Details subform. ...
    (microsoft.public.access.forms)
  • Re: Blank Subform
    ... So your main form has 4 subform controls (on different tab pages), ... Say the master field is ID1 and the child field is ID2, ...
    (microsoft.public.access.formscoding)
  • Re: subforms not requerying
    ... "Stephen Lebans" wrote: ... Not too many threads where you get Stephan, ... >> I tried the trick with additional textbox and linked the master field ... >> record in subform A, field SubRecordID which is one key column of the ...
    (microsoft.public.access.forms)