I need to add a related field in the CID form.
Correct?
."The only real mistake is the one from which we learn nothing."
John Powell (1834-1902)
John Powell (1834-1902)
"Patience is the companion of wisdom."
Saint Augustine (354 AD - 430 AD)
Saint Augustine (354 AD - 430 AD)
"Success is the ability to go from one failure
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, May 23, 2014 10:36 AM
Subject: Re: [MS_AccessPros] Related sub form control
John-
If the subform is Continuous or Datasheet view, there's really only ONE copy of each control. If your control to display the customer name is in the Detail section and is unbound, it will display the same value on all records.
What are the Recordsets of the outer and subform, which recordset has the customer name, and what in the subform records links to customer name?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On May 23, 2014, at 4:00 PM, John Heinze shelbysalpha@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have a sub form which has the customer name field from the form on it. I am trying to loop through the sub form record set and display the customer name from the sub form but the customer name doesn't change. The customer name is whichever record I am on in the form and is displayed for every record in the sub form. How do I get the customer name to "change" as I loop through the sub form?
."The only real mistake is the one from which we learn nothing."
John Powell (1834-1902)
John Powell (1834-1902)
"Patience is the companion of wisdom."
Saint Augustine (354 AD - 430 AD)
Saint Augustine (354 AD - 430 AD)
"Success is the ability to go from one failure
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
__._,_.___
Posted by: John Heinze <shelbysalpha@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar