Results 1 to 9 of 9
  1. #1
    gdboling
    Guest

    Table Field to Form Field Access 2K

    I am trying to take data from a field in a table and auto insert it into a field on a form. The reason I need it to go to the form is because other data in the form will be different so I need it then to create a new record in the Table when I click to the next record.

  2. #2
    Lounger
    Join Date
    Dec 2000
    Location
    Ohio, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table Field to Form Field Access 2K

    Hello,
    You can use Me.controlname.value = [your table value]
    "Me" is an Access function that associates with the current form.
    "controlname" is the name you gave the control (see properties other tab)
    "Value" lets Access know what to do
    "[your table value]" this is a value [] not needed
    Please look into this as I may have left something out.
    Good luck,

  3. #3
    gdboling
    Guest

    Re: Table Field to Form Field Access 2K

    What function do I use to make this happen? Do I use the AfterUpdate or what?? Sorry if I sound stupid. I'm new at this. <img src=/S/angel.gif border=0 alt=angel width=15 height=21>

    Also, there has to be some sort of check to see what Affiliation is associated with The name. For instance:

    If Name = Han Solo then
    check Affiliation of that record and insert it into the affiliation on the form.

    Does that make sense?

    Everything has to be dynamic too, so I don't want to have to create a record that contains every possible name with their affiliation etc, to pull from. I want to pull from the same record I am updating. The code should first check to see if the name exists already and if it does, jump to the autofill procedure that then checks that name's affiliation etc, and puts it in the form to create a new record

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table Field to Form Field Access 2K

    if you are just updating a record why not use a query to fill the form

  5. #5
    gdboling
    Guest

    Re: Table Field to Form Field Access 2K

    Ok, how do I do that? And how do I make the querry run automatically after I fill in the name field?

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table Field to Form Field Access 2K

    set the criteria for the query to the field you first fill in
    then in the afterupdate run the query

  7. #7
    gdboling
    Guest

    Re: Table Field to Form Field Access 2K

    A New Example:

    In Quicken or MS Money, when you type in the Pay To field, the rest of the fields fill in with the last data you entered for that Payee. that is similar to what I want to do, I just don't want every field to fill in like that. Only fields that remain the same for that Name field.

    Make more sense?

  8. #8
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table Field to Form Field Access 2K

    write a query with the fields you need for your form set the criteria of the field you will be typing in to the control of the form
    then in the after update of that control run the query

  9. #9
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table Field to Form Field Access 2K

    Are we addressing the same problem in this thread that we are addressing the Star Wars analogy thread ? I really think you need to look at table relationships. When quickbooks fills in fields on a form, it isn't creating a record/field, it's using table relationships and yes indeed an underlying query containing the related tables will give you access to these fields in a form or report.

Posting Permissions

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