Search results

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...

When you are in design mode on your form click on the view button. You will see TAB ORDER in the drop down box. click on it then you can put the fields in the order you want user to enter data in. Cindy

Well the relationships above are unreadable as they have shifted around so here it is again. PARENT ParID (PK) otherinfo RELATIVE RelParID (PK) RelChdID (PK) RelTyp CHILD ChildID other info The ParID is linked to RelParId and ChildID is linked to RelChdID. Cindy

Fizzio, Can I add a text box for a field that is not on the form and not in either the parent/grandparent or child table? The field I want to update is in the Relations table. PARENT RELATIONS CHILD ParID ---------> RelAdult |---> ChildID other info RelChild...

I have the following: 1. Parent information and student info in the subform. 2. Grandparent info and student info in the subform. 3. Child info and parent info in the subform. 4. Child info and Grandparent info in the subform. They are all different forms/subform. I have a table that links...

I have 4 form/subforms that I want to add a field to. The field is in a different table than the 2 tables currently being used. How can I add this new field to the existing form with out starting over? Ultimately what I would like to do is force a value into this new field based on which set...