Form ? (access 97)

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote