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

Run an Append Query based on values in a form

P: 2
I'm a fairly new access user so my question may be simple but I still need help! I have a form and a subform. I want to run an append query and populate the subform based on values in the form. I have a project number and an alpha number, I want to populate the subform (which is obviously connected to a table) based on the value that is in the main form. Is there a code? I have been able to do it successfully when I enter the two values however I can't get code to do it for me. Any thoughts?
Thanks in advance.
Oct 30 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
I'm a fairly new access user so my question may be simple but I still need help! I have a form and a subform. I want to run an append query and populate the subform based on values in the form. I have a project number and an alpha number, I want to populate the subform (which is obviously connected to a table) based on the value that is in the main form. Is there a code? I have been able to do it successfully when I enter the two values however I can't get code to do it for me. Any thoughts?
Thanks in advance.
Open the Main Form in design view.
Go to the subform object and click on the frame then open the properties window.
Under the data tab there are two properties called
Link Child Fields and Link Master Fields
If you click on the button with dots beside either of these fields it will open a wizard
The wizard will allow you to link the main form to the subform based on some value common to both.
Oct 30 '06 #2

Post your reply

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