Hi All,
I have a form that tracks problem issues. On that form I would like to
have 2 subforms with 1-to-many notes associated with each problem. On
the first subform I'd like to show a datasheet view of the associated
notes, with datecreated and notesubject. On the 2nd subform I'd like to
show a single form view of the actual note memo field.
I've placed an invisible sychronization field on the main form, which I
update from the On Current event of the first subform. The 2nd subform
uses this in the Link Master and Link Child fields.
It mostly works okay, but when I create a new record in the first
subform, and then click in the second subform to add the actual notes,
the second subform hasn't syched to the newly created record in the
first subform.
I'm wondering if anyone can tell me how I go about making this happen
automatically?
Note: Access 2003, if that's important.
Many thanks in advance!
Much warmth,
planetthoughtfu l
---
"Lost in thought" http://www.planetthoughtful.org 1 3047
when you add a new record in the first subform, after the record is saved to
the table, you'll need to requery the second subform so that the newly
created record is included in the recordset. you might try using the first
subform's Form_AfterUpdat e event procedure.
hth
"planetthoughtf ul" <pl************ **@gmail.com> wrote in message
news:11******** **************@ j33g2000cwa.goo glegroups.com.. . Hi All,
I have a form that tracks problem issues. On that form I would like to have 2 subforms with 1-to-many notes associated with each problem. On the first subform I'd like to show a datasheet view of the associated notes, with datecreated and notesubject. On the 2nd subform I'd like to show a single form view of the actual note memo field.
I've placed an invisible sychronization field on the main form, which I update from the On Current event of the first subform. The 2nd subform uses this in the Link Master and Link Child fields.
It mostly works okay, but when I create a new record in the first subform, and then click in the second subform to add the actual notes, the second subform hasn't syched to the newly created record in the first subform.
I'm wondering if anyone can tell me how I go about making this happen automatically?
Note: Access 2003, if that's important.
Many thanks in advance!
Much warmth,
planetthoughtfu l
--- "Lost in thought" http://www.planetthoughtful.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Tom |
last post by:
The purpose of my form is to record multiple owners of businesses. The main form
displays the business records. Subform1 is a continuous form consisting of only
a combobox to select owners from a table of owners. Subform1 contains record
selectors so after owners are entered, a specific owner can be selected. PK is
OwnerID. Subform2 is a single form based on the same owner table and its purpose
is to display details about the selected owner...
|
by: Steve |
last post by:
I have a form, primary subform and secondary subform. A tab control takes up all
the area of the primary subform. There are about 15 tabs on the tabcontrol. Each
tab contains fields from the same table. Related fields appear on each tab.
There is one field in the table that needs to be displayed at all times so I
created the secondary subform (subform to main form) to display just that one
field. Data entry is main form - secondary subform...
|
by: Diana Gard |
last post by:
Perhaps this is a design flaw, please let me know.
I'm using Access 2000. I have a form with a tab control and 5
subforms within those tabs. The forms match with the tables: Client
main, Intake, Financial, Fees, Payments, Bills, Bill Line Items. The
design works thusly - Client Main relates to Intake. Intake relates to
financial. Financial relates Fees, Payments and Bills. Bills relates
to Bill Line Items.
On the form, I use the...
|
by: Dale Walker |
last post by:
I've got a form that currently has a list box used to "find a record
on my form" but the list in it is far too long and consists of fields
of repeating data.
Is there a way of creating a subform to do the same job that is in
datasheet view with a collapsible subdatasheet?
The main form is based on a table consisting of dates, events and
venues (plus a lot of other guff not needed to explain this little
problem). Each record has an ID,...
|
by: tlyczko |
last post by:
I have a main form with 2 subforms, each subform references different
data in the same table.
How do I make sure each subform only creates NEW records in the
referenced table and do not overwrite or change data in previously
created rows??
Otherwise I have to use two different tables, with similar kinds of
data, for each subform, which may well be the way to go even though
it's not really normalized, to make the data entry easier and...
| |
by: collegekid |
last post by:
Hi everyone, basically my problem is this:
I am using an Access 2000 format.
And--I have four subforms in my main form. (Purpose of this is to track projects.) So in my main form I enter the project name, one primary point person for it (1:N list from a separate table), other details, and a manually entered tracking number, which is the primary key.
Now, I also need to put down the legal entities, business managers, financial...
|
by: Parasyke |
last post by:
I have a form to display inventoried items using Access2003. On this
form I have a subform that displays a list of all my inventoried items
in the form of a DATASHEET. What I would like to do is when I
double-click on an item on the subform I would like another subform to
display that lists more details about that item. Both subforms would be
getting data from the same table but the top subform would be just:
InventoryID, Manufacturer,...
|
by: philelpko |
last post by:
Good Morning all,
I have a main form with 3 subforms. All of the input data on all the forms is stored in the same table.
I started getting the message "the changes you requested to the table were not successful because they would create duplicate values in the index".
I decided to check that the form was trying to make more than one record on the same ID (Auto Number with no Duplicates allowed) and that windows wasnt lying.
After...
|
by: sparks |
last post by:
I was using this to swap out a form with subforms on it by just making
a copy and tying each to copy of the same table.
subformV1 tblVisit1
subformV2 tblVisit2
etc
Select Case TabCtl0.Value
Case 0: 'Initial Visit
Child6.SourceObject = "subformV1"
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |