If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Thanks Rick!
|
#2
|
|||
|
|||
Thanks Rick! But more owiees...
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 -----Original Message----- . |
#3
|
|||
|
|||
Thanks Rick! But more owiees...
On Mon, 31 May 2004 14:55:07 -0700, "Sandra Grawunder"
wrote: 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 EH!? You can't use a continuous form as a mainform, but it's perfectly straightforward - routine even - to use it as a Subform! John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#4
|
|||
|
|||
Thanks Rick! But more owiees...
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? -----Original Message----- On Mon, 31 May 2004 14:55:07 -0700, "Sandra Grawunder" wrote: 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 EH!? You can't use a continuous form as a mainform, but it's perfectly straightforward - routine even - to use it as a Subform! John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public . |
#5
|
|||
|
|||
Thanks Rick! But more owiees...
"Sandra" wrote in message
... 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? 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. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|