Criteria for opening form from a different subform

Hi Crystal,

I know that that makes sense, but the subform only has contributors in it.
Every record has a contribution. It would not be in the subform if it did not.
I am looking at the form right now and all the subform records for each
campaign have contributions so there are no enpty records. So can it be the
child/master link fields?

Best,
Scott

Crystal (strive4peace) wrote:
Hi Scott,

I think John (Hi John!) hit the nail on the head when he
said that blank records are probably due to contributors
having no pledge info.

I recommend you redesign your forms to use just ONE table
for each form. This will alleviate a lot of problems

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*

Good morning Crystal,

[quoted text clipped - 49 lines]
Thanks,
Scott

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200911/1

Dear Crystal and John,

I don't want anyone to get mad or annoyed because I really appreciate all the
help I get here and I do not want anyone to think otherwise, but PLEASE read
my answers. I read yours. The query returns results. No blank records. All I
want is for the subform, where there are no blank records, to allow me to
double click on a field and open aonther form, period. If there is a reason
why a query result would disallow a vb double click event to occur, please
let me know.

I understand that it is difficult to diagnose long distance, and I appreciate
your patience, especially when the vehuicle does not allow for you to see any
of this. But I really did tell all this many times in my posts. If I am being
unclear, let me know and I will try to be better about my descriptions.

My very best regards to all on this site.
Scott


Scott_Brasted wrote:
Hi Crystal,

I know that that makes sense, but the subform only has contributors in it.
Every record has a contribution. It would not be in the subform if it did not.
I am looking at the form right now and all the subform records for each
campaign have contributions so there are no enpty records. So can it be the
child/master link fields?

Best,
Scott

Hi Scott,

[quoted text clipped - 26 lines]
Thanks,
Scott

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200911/1

hi Scott,

we just don't have enough information about your database to
know why this is happening... the best we can do is make
educated guesses based on what we have seen in the past to
cause problems.

I will take a look -- email me your database and specify
exactly what to pick and click to generate this problem in
your message -- and put your name in the subject line

strive4peace2009 at yahoo.com

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*


Scott_Brasted via AccessMonster.com wrote:
Dear Crystal and John,

I don't want anyone to get mad or annoyed because I really appreciate all the
help I get here and I do not want anyone to think otherwise, but PLEASE read
my answers. I read yours. The query returns results. No blank records. All I
want is for the subform, where there are no blank records, to allow me to
double click on a field and open aonther form, period. If there is a reason
why a query result would disallow a vb double click event to occur, please
let me know.

I understand that it is difficult to diagnose long distance, and I appreciate
your patience, especially when the vehuicle does not allow for you to see any
of this. But I really did tell all this many times in my posts. If I am being
unclear, let me know and I will try to be better about my descriptions.

My very best regards to all on this site.
Scott


Scott_Brasted wrote:
Hi Crystal,

I know that that makes sense, but the subform only has contributors in it.
Every record has a contribution. It would not be in the subform if it did not.
I am looking at the form right now and all the subform records for each
campaign have contributions so there are no enpty records. So can it be the
child/master link fields?

Best,
Scott

Hi Scott,

[quoted text clipped - 26 lines]
Thanks,
Scott

Hi Scott,

Got your database

First thing I did was look at your relationship diagram.
Unless you have a specific reason not to, you should enforce
Referential Integrity (RI) on all relationships

I find it very useful to lay out the diagram so it flows as
records must be created. For instance, before you can use
ContributorID in the Pledges table, the Contributor record
must be created -- so move it to the left of Pledges. Same
with your Categories ... and so on

In the table designs, remove the DefaultValue of 0 on your
numeric foreign keys (FK). For instance,
Pledges.Contribution_CategoryID has a default value of zero
which will not match to any record in ContributionCatagories
-- and even if it did, it would probably not be right. Read
about this in Access Basics (link in my siggy -- and you
should also pay close attention to the Combobox example)

frmCamPledgeList
RecordSource: tblDonationCampaignSetup

subform Name: frmCamPledgeListSub
subform RecordSource:
SELECT tblPledges.DatePledged, tblPledges.AmountPledged,
tblPledges.Paid, tblPledges.PaymentDate
, tblContributors.ContributorID,
tblContributors.DonorFirstName,
tblContributors.DonorLastName, ([DonorFirstName] & " " &
[DonorLastName]) AS Name, tblPledges.Campaign_ID
FROM tblContributors
INNER JOIN tblPledges
ON tblContributors.ContributorID = tblPledges.ContributorID;

do not use NAME as a name of any of your objects (fields,
tables, aliases, etc), it is a reserved word

Problem names and reserved words in Access, by Allen Browne
http://www.allenbrowne.com/Ap****ueBadWord.html

Contributors is in a 1:many relationship with Pledges -- you
will have trouble adding records and changing contributor
information on this form. Best to base each form on just
one table.

Instead of pulling in the Contributors table to get the
name, base the RecordSource on Pledges and do this:

make ContributorID a combobox
RowSource:
SELECT ContributorID, (DonorFirstName + " ") & DonorLastName
AS Donor
FROM tblContributors
ORDER BY DonorFirstName, DonorLastName
ColumnCount -- 2
columnWidths -- 0;2
Listwidth -- 2.2 (sum of column widths + 0.2 for scrollbar)

here is the code you have to open the next form:

DoCmd.OpenForm "frmViewDonor", , ,
"tblContributors.[ContributorID] =" &
Forms!frmCamPledgeList!frmCamPledgeListSub.Form.id ContributorID

firstly, you should have just one ContributorID in the
RecordSource (and you do) -- so you should not be
specifying the tablename

second, you are behind the form with the ContributorID so
you can use a relative reference instead of an absolute one

Forms!frmCamPledgeList!frmCamPledgeListSub.Form.id ContributorID
-- Me.ContributorID

third, if you drop the combo in the ControlSource for
idContributorID on the Property sheet, you will find that
'tblContributors.ContributorID' doesn't match anything in
the list so it is not available as a value to use in the
code. Change the ControlSource to -- ContributorID
.... and actually, THIS IS THE REASON your form is not
opening with the right data smile

If you intend to let the user edit data in the second form,
you should not include information from PositionList in the
RecordSource -- you can show the Position in a combobox and
hide the ID as I suggested you do for Donor.

You should not use * to get fields from more than one table
in the RecordSource -- otherwise, the key fieldnames will be
duplicated (and that is not necessary). Instead, on the
occasion that you really do need to join fields from another
table in a RecordSource, use * on the main table the form is
based on and specifically choose fields from other tables.

POSITION, btw, is also a reserved word -- so change the
field name to something else like 'Posit' or 'Positn'


Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*

Crystal,

Wow is the only word that comes to mind.

I have gone through this extensive reply carefully a couple of times and I
have also carefully folllowed your instructions and suggestions. All seems
well except that, irony here - this is the only part I do not understand:

third, if you drop the combo in the ControlSource for
idContributorID on the Property sheet, you will find that
'tblContributors.ContributorID' doesn't match anything in
the list so it is not available as a value to use in the
code. Change the ControlSource to -- ContributorID
... and actually, THIS IS THE REASON your form is not
opening with the right data smile

And it,of course is the one thing I really need to understand. I assume you
are talking about the form frmCamPledgeList and it's combo box that supplies
the campaign record? After that I am lost. I tried changing the Control
Source to ContributorID, but that screws up the combo box and the vb for the
cbo gives me a run time error that says you cannot assign a value to this
object. So I think I do not know what you mean.

Sorry, you did yoeman's work and I am lacking.

Best,
Scott


Crystal (strive4peace) wrote:
Hi Scott,

Got your database

First thing I did was look at your relationship diagram.
Unless you have a specific reason not to, you should enforce
Referential Integrity (RI) on all relationships

I find it very useful to lay out the diagram so it flows as
records must be created. For instance, before you can use
ContributorID in the Pledges table, the Contributor record
must be created -- so move it to the left of Pledges. Same
with your Categories ... and so on

In the table designs, remove the DefaultValue of 0 on your
numeric foreign keys (FK). For instance,
Pledges.Contribution_CategoryID has a default value of zero
which will not match to any record in ContributionCatagories
-- and even if it did, it would probably not be right. Read
about this in Access Basics (link in my siggy -- and you
should also pay close attention to the Combobox example)

frmCamPledgeList
RecordSource: tblDonationCampaignSetup

subform Name: frmCamPledgeListSub
subform RecordSource:
SELECT tblPledges.DatePledged, tblPledges.AmountPledged,
tblPledges.Paid, tblPledges.PaymentDate
, tblContributors.ContributorID,
tblContributors.DonorFirstName,
tblContributors.DonorLastName, ([DonorFirstName] & " " &
[DonorLastName]) AS Name, tblPledges.Campaign_ID
FROM tblContributors
INNER JOIN tblPledges
ON tblContributors.ContributorID = tblPledges.ContributorID;

do not use NAME as a name of any of your objects (fields,
tables, aliases, etc), it is a reserved word

Problem names and reserved words in Access, by Allen Browne
http://www.allenbrowne.com/Ap****ueBadWord.html

Contributors is in a 1:many relationship with Pledges -- you
will have trouble adding records and changing contributor
information on this form. Best to base each form on just
one table.

Instead of pulling in the Contributors table to get the
name, base the RecordSource on Pledges and do this:

make ContributorID a combobox
RowSource:
SELECT ContributorID, (DonorFirstName + " ") & DonorLastName
AS Donor
FROM tblContributors
ORDER BY DonorFirstName, DonorLastName
ColumnCount -- 2
columnWidths -- 0;2
Listwidth -- 2.2 (sum of column widths + 0.2 for scrollbar)

here is the code you have to open the next form:

DoCmd.OpenForm "frmViewDonor", , ,
"tblContributors.[ContributorID] =" &
Forms!frmCamPledgeList!frmCamPledgeListSub.Form.i dContributorID

firstly, you should have just one ContributorID in the
RecordSource (and you do) -- so you should not be
specifying the tablename

second, you are behind the form with the ContributorID so
you can use a relative reference instead of an absolute one

Forms!frmCamPledgeList!frmCamPledgeListSub.Form.i dContributorID
-- Me.ContributorID

third, if you drop the combo in the ControlSource for
idContributorID on the Property sheet, you will find that
'tblContributors.ContributorID' doesn't match anything in
the list so it is not available as a value to use in the
code. Change the ControlSource to -- ContributorID
... and actually, THIS IS THE REASON your form is not
opening with the right data smile

If you intend to let the user edit data in the second form,
you should not include information from PositionList in the
RecordSource -- you can show the Position in a combobox and
hide the ID as I suggested you do for Donor.

You should not use * to get fields from more than one table
in the RecordSource -- otherwise, the key fieldnames will be
duplicated (and that is not necessary). Instead, on the
occasion that you really do need to join fields from another
table in a RecordSource, use * on the main table the form is
based on and specifically choose fields from other tables.

POSITION, btw, is also a reserved word -- so change the
field name to something else like 'Posit' or 'Positn'

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200912/1

Hi Scott,

"Wow is the only word that comes to mind."

gee thanks! you're welcome

"And it,of course is the one thing I really need to
understand. "

I am referring to the Property sheet for the control. Read
the Properties and Methods section in Access Basics.

~~~
go to the design view of frmCamPledgeListSub

Select the idContributorID control ... but since it is under
[Name], you cannot see it

To select it you can drop down the combobox at the top of
the Property sheet and choose -- idContributorID
(I don't know why you did not name the control the same as
the Controlsource -- but at least it is specific)

Once you do get the control selected, move it to the header
section where you can SEE it in Design View and set the
following properties:
Visible -- No (Format tab of Property sheet)
ForeColor -- White (Font Color icon)
BackColor -- Black (Paint Bucket icon)

On the DATA tab, you will see a property called --
ControlSource
click in it
when you do this, a drop-down arrow will appear to the right
-- this is the list of fields in your RecordSource. As you
can see, what you have it set to is not in the list...

these link controls are very important. It is one thing to
hide them from users when they view the form, but you need
to be able to see them right away when you look at the
design -- that is why I had you set it to be white on black.

"but that screws up the combo box and the vb for the cbo
gives me a run time error that says you cannot assign a
value to this object. "

if you still get an error, try to explain this better ...

"you did yoeman's work"

don't quite understand what you mean, but I will take it as
a compliment



Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*


Scott_Brasted via AccessMonster.com wrote:
Crystal,

Wow is the only word that comes to mind.

I have gone through this extensive reply carefully a couple of times and I
have also carefully folllowed your instructions and suggestions. All seems
well except that, irony here - this is the only part I do not understand:

third, if you drop the combo in the ControlSource for
idContributorID on the Property sheet, you will find that
'tblContributors.ContributorID' doesn't match anything in
the list so it is not available as a value to use in the
code. Change the ControlSource to -- ContributorID
... and actually, THIS IS THE REASON your form is not
opening with the right data smile

And it,of course is the one thing I really need to understand. I assume you
are talking about the form frmCamPledgeList and it's combo box that supplies
the campaign record? After that I am lost. I tried changing the Control
Source to ContributorID, but that screws up the combo box and the vb for the
cbo gives me a run time error that says you cannot assign a value to this
object. So I think I do not know what you mean.

Sorry, you did yoeman's work and I am lacking.

Best,
Scott

Good morning Crystal,

Did you get this to work in your copy of the db? I followed your instructions
to the letter and I still get a blank form except for first record. Here is
what I did.
First changed all occurances of Name and Position to DonorName and Positn,
then:
1. moved idContributorID to subform header
2. renamed idContributorID control to ContributorID
3. changed background to black and text to white
4. selected ContributorID from Control Source dropdown list in property sheet
for text box control that is now in header of subform
5. saved subform
6 decided needed fresh start & deleted cbo & replaced w/Campaign Name field
temporarily in main form. will revisit soon.
7. saved main form.
8. double checked doubleclick event vb code on field "Donor_Name" for names,
etc. & changed idContributorID to ContributorID. Here is current code:
Private Sub Donor_Name_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmViewDonor", , , "ContributorID=" & Me.ContributorID
End Sub
9. saved code
10. restarted Access

No joy. Still blank records.
Scott


Crystal (strive4peace) wrote:
Hi Scott,

"Wow is the only word that comes to mind."

gee thanks! you're welcome

"And it,of course is the one thing I really need to
understand. "

I am referring to the Property sheet for the control. Read
the Properties and Methods section in Access Basics.

~~~
go to the design view of frmCamPledgeListSub

Select the idContributorID control ... but since it is under
[Name], you cannot see it

To select it you can drop down the combobox at the top of
the Property sheet and choose -- idContributorID
(I don't know why you did not name the control the same as
the Controlsource -- but at least it is specific)

Once you do get the control selected, move it to the header
section where you can SEE it in Design View and set the
following properties:
Visible -- No (Format tab of Property sheet)
ForeColor -- White (Font Color icon)
BackColor -- Black (Paint Bucket icon)

On the DATA tab, you will see a property called --
ControlSource
click in it
when you do this, a drop-down arrow will appear to the right
-- this is the list of fields in your RecordSource. As you
can see, what you have it set to is not in the list...

these link controls are very important. It is one thing to
hide them from users when they view the form, but you need
to be able to see them right away when you look at the
design -- that is why I had you set it to be white on black.

"but that screws up the combo box and the vb for the cbo
gives me a run time error that says you cannot assign a
value to this object. "

if you still get an error, try to explain this better ...

"you did yoeman's work"

don't quite understand what you mean, but I will take it as
a compliment

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*

Crystal,

[quoted text clipped - 23 lines]
Best,
Scott

--
Message posted via http://www.accessmonster.com

Hi Scott,

yes, it worked for me

send me the db, I will look again -- and make sure your
relationship diagram is laid out well as I will look at that
first smile

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*


Scott_Brasted via AccessMonster.com wrote:
Good morning Crystal,

Did you get this to work in your copy of the db? I followed your instructions
to the letter and I still get a blank form except for first record. Here is
what I did.
First changed all occurances of Name and Position to DonorName and Positn,
then:
1. moved idContributorID to subform header
2. renamed idContributorID control to ContributorID
3. changed background to black and text to white
4. selected ContributorID from Control Source dropdown list in property sheet
for text box control that is now in header of subform
5. saved subform
6 decided needed fresh start & deleted cbo & replaced w/Campaign Name field
temporarily in main form. will revisit soon.
7. saved main form.
8. double checked doubleclick event vb code on field "Donor_Name" for names,
etc. & changed idContributorID to ContributorID. Here is current code:
Private Sub Donor_Name_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmViewDonor", , , "ContributorID=" & Me.ContributorID
End Sub
9. saved code
10. restarted Access

No joy. Still blank records.
Scott


Crystal (strive4peace) wrote:
Hi Scott,

"Wow is the only word that comes to mind."

gee thanks! you're welcome

"And it,of course is the one thing I really need to
understand. "

I am referring to the Property sheet for the control. Read
the Properties and Methods section in Access Basics.

~~~
go to the design view of frmCamPledgeListSub

Select the idContributorID control ... but since it is under
[Name], you cannot see it

To select it you can drop down the combobox at the top of
the Property sheet and choose -- idContributorID
(I don't know why you did not name the control the same as
the Controlsource -- but at least it is specific)

Once you do get the control selected, move it to the header
section where you can SEE it in Design View and set the
following properties:
Visible -- No (Format tab of Property sheet)
ForeColor -- White (Font Color icon)
BackColor -- Black (Paint Bucket icon)

On the DATA tab, you will see a property called --
ControlSource
click in it
when you do this, a drop-down arrow will appear to the right
-- this is the list of fields in your RecordSource. As you
can see, what you have it set to is not in the list...

these link controls are very important. It is one thing to
hide them from users when they view the form, but you need
to be able to see them right away when you look at the
design -- that is why I had you set it to be white on black.

"but that screws up the combo box and the vb for the cbo
gives me a run time error that says you cannot assign a
value to this object. "

if you still get an error, try to explain this better ...

"you did yoeman's work"

don't quite understand what you mean, but I will take it as
a compliment

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*

Crystal,

[quoted text clipped - 23 lines]
Best,
Scott

Hi Scott,

yes, it worked for me

send me the db, I will look again -- and make sure your
relationship diagram is laid out well as I will look at that
first smile

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*


Scott_Brasted via AccessMonster.com wrote:
Good morning Crystal,

Did you get this to work in your copy of the db? I followed your instructions
to the letter and I still get a blank form except for first record. Here is
what I did.
First changed all occurances of Name and Position to DonorName and Positn,
then:
1. moved idContributorID to subform header
2. renamed idContributorID control to ContributorID
3. changed background to black and text to white
4. selected ContributorID from Control Source dropdown list in property sheet
for text box control that is now in header of subform
5. saved subform
6 decided needed fresh start & deleted cbo & replaced w/Campaign Name field
temporarily in main form. will revisit soon.
7. saved main form.
8. double checked doubleclick event vb code on field "Donor_Name" for names,
etc. & changed idContributorID to ContributorID. Here is current code:
Private Sub Donor_Name_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmViewDonor", , , "ContributorID=" & Me.ContributorID
End Sub
9. saved code
10. restarted Access

No joy. Still blank records.
Scott


Crystal (strive4peace) wrote:
Hi Scott,

"Wow is the only word that comes to mind."

gee thanks! you're welcome

"And it,of course is the one thing I really need to
understand. "

I am referring to the Property sheet for the control. Read
the Properties and Methods section in Access Basics.

~~~
go to the design view of frmCamPledgeListSub

Select the idContributorID control ... but since it is under
[Name], you cannot see it

To select it you can drop down the combobox at the top of
the Property sheet and choose -- idContributorID
(I don't know why you did not name the control the same as
the Controlsource -- but at least it is specific)

Once you do get the control selected, move it to the header
section where you can SEE it in Design View and set the
following properties:
Visible -- No (Format tab of Property sheet)
ForeColor -- White (Font Color icon)
BackColor -- Black (Paint Bucket icon)

On the DATA tab, you will see a property called --
ControlSource
click in it
when you do this, a drop-down arrow will appear to the right
-- this is the list of fields in your RecordSource. As you
can see, what you have it set to is not in the list...

these link controls are very important. It is one thing to
hide them from users when they view the form, but you need
to be able to see them right away when you look at the
design -- that is why I had you set it to be white on black.

"but that screws up the combo box and the vb for the cbo
gives me a run time error that says you cannot assign a
value to this object. "

if you still get an error, try to explain this better ...

"you did yoeman's work"

don't quite understand what you mean, but I will take it as
a compliment

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*

Crystal,

[quoted text clipped - 23 lines]
Best,
Scott

Hi Scott,

yes, it worked for me

send me the db, I will look again -- and make sure your
relationship diagram is laid out well as I will look at that
first smile

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*


Scott_Brasted via AccessMonster.com wrote:
Good morning Crystal,

Did you get this to work in your copy of the db? I followed your instructions
to the letter and I still get a blank form except for first record. Here is
what I did.
First changed all occurances of Name and Position to DonorName and Positn,
then:
1. moved idContributorID to subform header
2. renamed idContributorID control to ContributorID
3. changed background to black and text to white
4. selected ContributorID from Control Source dropdown list in property sheet
for text box control that is now in header of subform
5. saved subform
6 decided needed fresh start & deleted cbo & replaced w/Campaign Name field
temporarily in main form. will revisit soon.
7. saved main form.
8. double checked doubleclick event vb code on field "Donor_Name" for names,
etc. & changed idContributorID to ContributorID. Here is current code:
Private Sub Donor_Name_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmViewDonor", , , "ContributorID=" & Me.ContributorID
End Sub
9. saved code
10. restarted Access

No joy. Still blank records.
Scott


Crystal (strive4peace) wrote:
Hi Scott,

"Wow is the only word that comes to mind."

gee thanks! you're welcome

"And it,of course is the one thing I really need to
understand. "

I am referring to the Property sheet for the control. Read
the Properties and Methods section in Access Basics.

~~~
go to the design view of frmCamPledgeListSub

Select the idContributorID control ... but since it is under
[Name], you cannot see it

To select it you can drop down the combobox at the top of
the Property sheet and choose -- idContributorID
(I don't know why you did not name the control the same as
the Controlsource -- but at least it is specific)

Once you do get the control selected, move it to the header
section where you can SEE it in Design View and set the
following properties:
Visible -- No (Format tab of Property sheet)
ForeColor -- White (Font Color icon)
BackColor -- Black (Paint Bucket icon)

On the DATA tab, you will see a property called --
ControlSource
click in it
when you do this, a drop-down arrow will appear to the right
-- this is the list of fields in your RecordSource. As you
can see, what you have it set to is not in the list...

these link controls are very important. It is one thing to
hide them from users when they view the form, but you need
to be able to see them right away when you look at the
design -- that is why I had you set it to be white on black.

"but that screws up the combo box and the vb for the cbo
gives me a run time error that says you cannot assign a
value to this object. "

if you still get an error, try to explain this better ...

"you did yoeman's work"

don't quite understand what you mean, but I will take it as
a compliment

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day
*

Crystal,

[quoted text clipped - 23 lines]
Best,
Scott