Results 1 to 3 of 3

Thread: Autofill (2003)

  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Autofill (2003)

    This is drivin' me nuts! I did a search on autofill and found a lot of info (particularly <!post=Han's post,248858>Han's post<!/post> ) but I guess I just don't get it. At this point I can't make any data entry whatsoever on the form I've screwed it up so bad. I want to have the Job Site combo box auto fill the address info. I figured I could do this with a query (as per Hans). Any help greatly appreciated.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Autofill (2003)

    The record source of the form is the query qryMaster. This query is not updateable. This is because the link between the two tables doesn't have a unique index on either side.

    The tblMaster table contains a text field txtJobSite. This is not correct. It should contain a number field lngJobID that is linked to the ID field in the tblJobSites table. The latter field should be the primary key of tblJobSites.

    The tables in the query should be linked on lngJobID vs ID. Since ID is now the primary key, the query will be updateable.

    The design of the combo box on the form must be bound to lngJobID, and the row source should include the ID field. See the attached version.
    Attached Files Attached Files

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Autofill (2003)

    I see (said the blind man).

    Part of what threw me was in the other demo (I don't believe that was created by you) it shows a relationship between "Name" and "ID". I thought that was kind of weird, but I tried it anyway (File Type Mismatch). Now that I look at that table in the demo again I see where "Name" is actually a number. Also, there is no "vets" table as discribed in your text on that post (I guess the original poster changed it) so I was also confused as to what table you refered to.

    Not making excuses here (no, really! <img src=/S/groan.gif border=0 alt=groan width=16 height=15> ), I confuse myself without any help whatsoever, but I was really <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15> by the time I tried to apply the demo to my application.

    A million thanks for bailing me out of trouble again!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •