Run an Append Query based on values in a form

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

Subscribe Post Reply

3653

MMcCarthy

14,534

Expert Mod 8TB

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

Similar topics

Append query help

by: John | last post by:

Hi - I am trying to perform a simple append query, with no luck. I have a table (MktPrices) that has the following fields: BondID, PriceDate, Price. The objective is to allow the user to input a...

Microsoft Access / VBA

'''''''''''''The Running Update/Append Queries Using VBA code Ordeal''''''''''''''

by: Aaron | last post by:

Hello fellow programmers, I am trying to run an append/update query from code, a command button on a form initiates the queries. the format i am using is; ...

Microsoft Access / VBA

Multiple Criteria Parameter Query

by: dskillingstad | last post by:

I'm trying to set up a parameter query based on an unbound form. This search form has about 5 text boxes where the user can type in values within each box and search a specific table based on the...

Microsoft Access / VBA

Problem turning off action messages in runtime - append query not working

by: Lee | last post by:

Hello All, First of all I would like to say thank you for all of the help I have received here. I have been teaching myself Access for about 4 years now and I've always been able to find a...

Microsoft Access / VBA

Append Query - Only Appends 1 ID (Need more)!!

by: robertmeyer1 | last post by:

Hey, I have 2 append queries. The first is based off of code given and works great. For the second, I followed the format of the 1st and adjusted it to meet my needs. Query 1 works great. It...

Microsoft Access / VBA

Append Query Using Form textbox functions issue

by: DHarris | last post by:

I created a continuous form in Access2003 based on a query that users review customers and once reviewed clicks on a command button that executes an append query to update a table of the reviewed...

Microsoft Access / VBA

Append Query, duplicates

by: Scott12345 | last post by:

Hi, here is my situation, I have a DB that tracks machine downtime (30 machines) per day. Several users will update this through the day. I created an append query that creates 30 dummy values and...

Microsoft Access / VBA

MS Access Append Record

by: hikosj | last post by:

Hi all, I have a problem with a query in access that I cant seem to figure out. I have a form named frmRecruitment with a subform named sfrmParticipant. At the moment I am using an append query to...

Microsoft Access / VBA

Append Query Error Trapping

by: franc sutherland | last post by:

Hello, I am using Access 2003. I am having trouble trapping the "can't append all the records in the append query" error message when appending data to a query from a table which is linked to...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice