Thanks Rick!

  • Thread starter Thread starter Sandra
  • Start date Start date
Well fiddlesticks, I thought we might have it there, but
I have tried your suggestions and a couple of others and
I still can't get these forms to link. My main reason to
try and use a popup form is because I need my Donations
form to be Continuous and it can't be if I put in a
subform, and I also have one other table similar to
InKind that I will need to do the same thing for if I can
make this work. There are several different types of
donations but only InKind and HonorMemory requires extra
information. Here is the basic structure of the tables:

DONATIONS Table: INKIND Table:
DID - Donations PK IKID - InKind PK
RID - Link to Relations table DID - Link to Donations

The only way I have been able to establish a link is by
manually typing in the DID value from DONATIONS into the
DID field for INKIND. Even then, the forms don't sync,
although in the underlying tables they are correct and
maintain referential integrity.

Private Sub Category_AfterUpdate()
Dim strFormName As String
Select Case Me.Category.Value
Case "In-Kind"
Me.Refresh
strFormName = "DInKind"
DoCmd.OpenForm strFormName, , , , , acDialog
Case "Honor Of", "Memory Of"
Me.Refresh
strFormName = "DHonorMemory"
DoCmd.OpenForm strFormName, , , , , acDialog
End Select
strFormName = ""

Have you got any other ideas or suggestions on how I
could make this work?

And not to wear out my welcome, but here's another
problem I would like to solve. I want this relationship
as 1 to 1, i.e. only one InKind record for each Donation
record. Is there a way to restrict the entry on the
popup form to just one record when triggered by the
Donation entry?

Thanks so much for your help!
Sandra
 
My main reason to
try and use a popup form is because I need my Donations
form to be Continuous and it can't be if I put in a
subform
Click to expand...

EH!?

You can't use a continuous form as a mainform, but it's perfectly
straightforward - routine even - to use it as a Subform!
 
Well John, I tried to place the InKind form as a subform
into the Donations subform, and when I do, Access gives
me a message and changes the Donation form from
continuous to single.
Am I doing something else wrong?
 
Sandra said:
Well John, I tried to place the InKind form as a subform
into the Donations subform, and when I do, Access gives
me a message and changes the Donation form from
continuous to single.
Am I doing something else wrong?
Click to expand...

I believe John thought you meant that the subform could not be continuous.
You can place a subform in the header or footer of a continuous form and it
will work.
 
Back
Top