Full Version: Add Recordto Table From Form
UtterAccess Forums > MicrosoftŪ Access > Access Forms
waseemthonse
Hi,

I have a form when i click save button, records are added to the table BANK TRANSACTION from anothet table TEMPBANKTRANSACTION.It works fine. But i want to add date to the BANK TRANSACTION table from txtDate from Form. I want to modify below code. How i can add the date to BANK TRANSACTION table from Form?Please check the below code and help me to solve this...
DoCmd.RunSQL "INSERT INTO BANKTRANSACTION (ACDYRID, FDAMOUNT,DESCRIPTION, PVOUCHERID, ACTLEDID,COMNAME,USERID )" _
& "SELECT ACDYRID,ACTDEP,'A/c',PVOUCHERID,ACTLEDID,fOSUserName(),GetUserid()" _
& "FROM TEMPBANKTRANSACTION WHERE (((TEMPBANKTRANSACTION.MySelection)=-1));"
Any help??
waseem
waseemthonse
Hi,
That is fine. But it will give the current date. But i want to add the date from the form. The date on the form is not current date.It is the one enetered by the user.
Any help?
waseem iconfused.gif
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.