Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update Tables (Access 97)

    <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    Good Morning,

    OK...I'm stuck. I have a table, tblTracker that is used as the record source for a form. One of the fields in tblTracker is EIN. I also have a table, tblEINUpdate. I need, when user inputs, the EIN to be updated in tblEINUpdate.

    Can someone provide me with a solution please.

    Thanks in advance.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Tables (Access 97)

    It's not very clear what you want to do.
    Are the tables related?
    Is there on record you want to update or do you want to append a new record with the changes?
    You could put some code in the before or after update of the EIN control or those of the form.
    Francois

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Tables (Access 97)

    I'm sorry for being vague.

    Each time the field, txtEIN, in frmTracker is updated, I want to field in tblEINUpdate to be updated.

    Hope that is more clear.

    Thanks for your help.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Tables (Access 97)

    I suppose the two tables have some relationship.
    In the query under the frmTracker, add the field tblEINUpdate.
    On the form, you can put an invisible control, with the tblEINUpdate field.
    In the before update event of the form, put the code :
    Me!txtEINUpdate = Me!txtEIN
    where txtEINUpdate the name is of the invisible control.

    Why are you keeping this data in two different tables ?
    If something goes wrong with the form, the data can become inconsistent.
    It's not usual to store the same data twice in the same database.
    Francois

Posting Permissions

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