Hi Guys,
I'm in the process of creating two forms, each with a subform, that will be used to populate my tables. I've attached a screen shot of the relationships that exist between my tables and I've also attached a screen shot of one of the Form/subform's I created.
The problem I'm having is when entering anew record. I can in put GrantName, Principle Investigator, and project title with ease, and can move through these using the Tab key.
What I'd like to do is tab from the ProjectTitle to the Institutions Subform. Then I'd like to either add a new institution or have the Institution i'm looking for self-propagate. Then I'd like to Tab to the InstitutionID field back on the Parent Form.
The problem I'm encountering now is that the Tab function only goes through the first four fields (ApplicantID, GrantName, Principle Investigator, and Project Title) and then I have to use my mouse to click into the InstitutionID field. I can then randomly select a number and hope it comes up in the Institution SubForm. This is problematic for a couple of reasons: 1. if users don't know which institution is related to record 238, for instance, they won't be able to fill out the form and populate the All Applicants Table. 2. If a new Institution needs to be added, I can do that below first, but I can't Tab to the subform without first filling out the parent form.
A second problem I'm encountering is that I cannot add a new entry using this form without indicating a GrantID, which I find odd, because in the Parent table (All Applicants Table) every record isn't associated with a GrantID, so I thought I should be able to add multiple records to the All Applicant Table without specifying a GrantID.
I do not want users to have to fill out the GrantID field in this form, rather I'd like them to have to fill that information out in the second form I create for Awarded Grants, once news of awarded grants is obtained.
If you guys have any suggestions as to how I can fix these issues I'd really appreciate it.
Maria
I'm in the process of creating two forms, each with a subform, that will be used to populate my tables. I've attached a screen shot of the relationships that exist between my tables and I've also attached a screen shot of one of the Form/subform's I created.
The problem I'm having is when entering anew record. I can in put GrantName, Principle Investigator, and project title with ease, and can move through these using the Tab key.
What I'd like to do is tab from the ProjectTitle to the Institutions Subform. Then I'd like to either add a new institution or have the Institution i'm looking for self-propagate. Then I'd like to Tab to the InstitutionID field back on the Parent Form.
The problem I'm encountering now is that the Tab function only goes through the first four fields (ApplicantID, GrantName, Principle Investigator, and Project Title) and then I have to use my mouse to click into the InstitutionID field. I can then randomly select a number and hope it comes up in the Institution SubForm. This is problematic for a couple of reasons: 1. if users don't know which institution is related to record 238, for instance, they won't be able to fill out the form and populate the All Applicants Table. 2. If a new Institution needs to be added, I can do that below first, but I can't Tab to the subform without first filling out the parent form.
A second problem I'm encountering is that I cannot add a new entry using this form without indicating a GrantID, which I find odd, because in the Parent table (All Applicants Table) every record isn't associated with a GrantID, so I thought I should be able to add multiple records to the All Applicant Table without specifying a GrantID.
I do not want users to have to fill out the GrantID field in this form, rather I'd like them to have to fill that information out in the second form I create for Awarded Grants, once news of awarded grants is obtained.
If you guys have any suggestions as to how I can fix these issues I'd really appreciate it.
Maria