Re: 1 Subform feeding into 2 tables

From: EMS (EMS_at_discussions.microsoft.com)
Date: 12/18/04 

Date: Fri, 17 Dec 2004 16:07:02 -0800

As far as the link, this is the error message that comes up:

ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/Otherdownload.asp, line 32

As far as the rest goes. Yes I know that a subform works using a
master/child link field and I know that it requires No vb code. I'll try
explaining how i have this set up.

tblMain
     pk-SRID
         DateSurveycompleted
         etc.

tblInitial
     pk-SRIID
     fk-SRID
         Q1-50

tblLong
     pk-SRLID
     fk-SRID
         Q51-130

Then here is the form situation:
 
frmMain (includes all fields from tblMain)

frmLong (using a select statement in the recordsource property I include ALL
fields from both tblInitial and tblLong, including the SRID from both of
those tables). So what I tried to do was do a double master/child link where
the SRID from tblMain was linked to both SRID fields (on the form). I hope
that I have explained this well enough.

Thanks again for all your help on this.....

"John Vinson" wrote:

> On Thu, 16 Dec 2004 09:45:05 -0800, EMS
> <EMS@discussions.microsoft.com> wrote:
>
> >Thank you for your response John. Yes, I remember being told the same as
> >you're telling me now about survey db's and how they should be normalized. I
> >just had a hard time wrapping my mind around the whole concept. I tried to
> >find the sample database with the link that you supplied, but for some reason
> >it is not working. Your continued help in pointing me in the right direction
> >is much appreciated!
> >
> >Oh, also in response to the latter part of your post. No it is a subform,
> >it is not a pop-up. And yes, I began trying to figure out some code to work
> >through this but have had a difficult time figuring out the whole
> >recordsetclone and bookmark concepts. Yes, i have minimal understanding of
> >vb programming, but I know that I am very much a beginner is several respects.
>
> A Subform works using its Master/CHild Link Field. It requires *NO*
> VBA code at all. What is the structure of your form? What are the
> Recordsource queries of the three forms? What are the Master/Child
> Link Fields?
>
> As for Duane's demo database, the link works for me; I connected to it
> and copied the link directly to my message. What problem are you
> having with it?
>
> John W. Vinson[MVP]
> Join the online Access Chats
> Tuesday 11am EDT - Thursday 3:30pm EDT
> http://community.compuserve.com/msdevapps
>

Relevant Pages

  • Re: how to call function
    ... It looks like Access is recognizing "seconds" as a field in the recordsource ... of your form and, thus, adding the brackets. ... Do you get an error message? ... In another unbound text box I ...
    (microsoft.public.access.forms)
  • Re: Join Key not in recordset
    ... "John W. Vinson" wrote: ... can't write anything and I get the error message "Cannot add record. ... field in fact in the recordsource? ...
    (microsoft.public.access.forms)
  • RE: DLookup Missing RecordSource Question
    ... RowSource of your combo box. ... far as a test) and I am getting a strange almost oxymoronic error message, ... Dim dlookClientLastName As String ... The name of the recordsource may be misspelled, ...
    (microsoft.public.access.formscoding)
  • Re: 2465 error on non-cascade delete
    ... if you are still getting the "Forms" error message after the Forms ... rather than allenbrowne at mvps dot org. ... as the form's RecordSource does have such as reference. ...
    (microsoft.public.access.modulesdaovba)