Recent content by cindyareed

David, I have gone though my code, query and forms and renamed all to get rid of "/" and spaces. However I am back to the beginning again. How do I get the value from the ParParID field (which is a combo box) on the subform to the form displayed when a double click is performed on that field...

You are right, I should have done that to begin with...If I change the names of my forms and querys will it propigate/ripple though what I have already set up? I appreciate your time on this, Cindy

David, Thanks for your help but I am still having trouble. The field ParParID is a combo box. I am getting a run time error: 2450 it can not find form 'Form - Student/Parent query Subform' referred to in a macro or VB code. I have tried a couple of other things and get other errors or this...

David, Still hoping you can help me on the code from my last post. Thanks, Cindy

David, Here is what I have: 1. Form name: Form - Student/Parent Query Form Query name: Student Query 2. Subform name: Form - Student/Parent query Subform Query name: Form - ParentToStudent query Field name: ParParID 3. From called on double click: Form - Parent query Query name...

David, I did as you have above and switched from a Macro to the code and I am still getting the "enter parameter value' window. How do I get it to bypass that and go directly to the form in edit mode. (if I enter the Parent ID into the window and press enter I am getting the correct record in...

David, ok I need some luck...I am not getting this! I have a form with student info (FStud). The form has 2 tabs and each of those has a subform on it, one with parent info (FStudParSF). If the user double clicks on the ParParID field the parent form will display (FPar). I have tried...

OK I got that but now I am getting a enter parameter value which I don't want the user to have to enter. Can you point me in the right direction on having the value from the original form passing the value to the new form. Thanks very much for your help, I appreciate that you told me where to...

I have set up my subform with a combo box that will allow the user to create a new record if "not in list". I also want the user to beable to update an existing record if they double click the combo box. The correct form displays on both of the above conditions except I want the update to...

Pat, Thanks for the Many to Many sample. I have looked the tables, queries and forms to compare the sample to what I have. I think mine is very similar to the sample and my form is doing basically what yours is doing. Is it possible to create a new record in the form and one in the...

Thanks Pat, Will send you and E-mail. Cindy

Pat, I did look at the web site info you gave me that and I thought I had my tables set up that way? Don't I? I have one parent record, one student record and the Relationship table has the many, linking the parent to their children. I thought I understood this. Do I still have it wrong...

I have a form that contains my student information. That form has 2 tabs, one has the Parent subform attached to it and the other tab has the Grandparent subform. I can create the Student record but the Relationship table record is not being created when a parent already exists. I am using...

I have tried numerous times and ways to place my subform to a tab but the tab never goes dark. What am I doing wrong? Thanks Cindy

Fizzio, Thanks for your recomendation about using queries instead of tables to create forms. I have changed my approach and am getting closes to what I expect. I was wondering if there is a way to have a form and "toggle" between two subforms. I have created a Student form and have the...