Hi
i have some solutions but i am looking for more ideas on ho to go about it. I have a form that is a Claim. each claim involves an employee. the employee should be entered if there were no other claims for this employee. so employee is related to claim one-to-many. the main form's datasource is a query that has the claim table and employee table. i am trying to set up either a subform or part of the main form a way that an employee can be looked up and if not found entered.
this what i have now. a combo showing all existing employees. i then have a tab control, the first tab showing the existing employees. if a new employee is to be entered then the second tab comes up (seamlessly, not visible that there are two tabs) which has a subform. tab1 has bounded fields, and tab2 (the subform) has unbounded fields. so in order to gather the info of tab2, a long sub has to be written.
any ideas on how to do this in a less complicated way?
thanks,
sam
i have some solutions but i am looking for more ideas on ho to go about it. I have a form that is a Claim. each claim involves an employee. the employee should be entered if there were no other claims for this employee. so employee is related to claim one-to-many. the main form's datasource is a query that has the claim table and employee table. i am trying to set up either a subform or part of the main form a way that an employee can be looked up and if not found entered.
this what i have now. a combo showing all existing employees. i then have a tab control, the first tab showing the existing employees. if a new employee is to be entered then the second tab comes up (seamlessly, not visible that there are two tabs) which has a subform. tab1 has bounded fields, and tab2 (the subform) has unbounded fields. so in order to gather the info of tab2, a long sub has to be written.
any ideas on how to do this in a less complicated way?
thanks,
sam
