By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,461 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

CmdSave button

P: 9

I have maid some changes from my original posting. I hope someone will be able to help me out. If someone could provide me with the VB code for this I would greatly appreciate it. If not could someone please give me a reference. On my main form [Frm_Main] I have a combo box [cboFollowUp] when a selection is made form [Frm_FollowUp] pops up.

On form [Frm_FollowUp] all the fields that I want are populated. The fields are:

Acct# - Control Source =Forms![Frm_Main]![ACCT#]
PT Name Control Source =Forms![Frm_Main]![PT_Name]
Acct Balance Control Source =Forms![Frm_Main]![ACCT BAL]
Activity Control Source =Forms![Frm_Main]!cboFollowUp
Initial Control Source =Forms![Frm_Main]![IN]
Financial Control Source =Forms![Frm_Main]!CAR1
Date Unbound, Default Value set to =Now()
Follow up date Unbound, field is populated when selection is made from MS Calendar7 which is on the form.
Notes unbound, (a field to add notes, 255 characters max)

I have save button [cmdSave] on this form, when it is click I would like all the fields above to be copied to table [Tbl_followUp_Activities]. The table [Tbl_followUp_Activities] has all the fields listed. Any help at all I would really appreciate. Thanks!
Nov 28 '06 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,661
One way of doing it would be to formulate an append (INSERT INTO ...) SQL string which includes all the values you have available on your form then execute it.
Expand|Select|Wrap|Line Numbers
  1. INSERT INTO [Tbl_followUp_Activities] ( [Acct#], etc )
  2. SELECT Forms![Frm_FollowUp].[Acct#], etc;
Nov 28 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.