Re: Pull last data record into a new table
Posted by: Mike F
Date: June 18, 2020 03:01PM

Actually got it to work going a different route - in which I declare the value in the field and then write it in directly.

Here's the code for reference as to how I got the name to populate in both tables (direct record input from form for table 1 and then the below code on click event):

Dim projnamedata As Variant
Dim dbs As Database
projnamedata = Me.txt_projname.Value

DoCmd.GoToRecord , "", acNewRec

Set dbs = CurrentDb
dbs.Execute "INSERT INTO tbl_ProjDetails (ProjName) VALUES('" & projnamedata & "')"

Options: ReplyQuote

Written By
Re: Pull last data record into a new table
June 18, 2020 03:01PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.