Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2007
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form ? (access 97)

    I have a unique situation. I need to know how I can do this. I have a database called userdb with a form called userform. What I need is that after a user adds data to the fields on the userform in userdb, the hit a button and the data from those fields would populate a form in another database called receiptdb with a form called receipt form. These 2 db were set up a long time ago and they don't want to pay for a redesign. So I'm trying to make it so the user would just click a button on the userdb and the data would then show up in the receiptdb recipt form. It would save them from having to type the same data over again. Is this possible? Would I have to link the tables from the receiptdb into the user db and then make a new receipt form in the userdb? Thanks for the help.

  2. #2
    Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form ? (access 97)

    You could use DLookups or recordset code to update the other database. DLookups are easier, but may be slower.

Posting Permissions

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