Need Help-Combo Box headache

[Guest]

Stumped big time! I have a form with a query for a source. I have a subform
on the mainform.I have a combo box on the main form which has id numbers, and
tech names. When I start a new record I select a id number I start entering
in customer name and address info along with the id# on the main form. In the
subform I am entering time and task information. The problem is that when I
select a new record and enter in a id# that exists from another record it is
pulling up that information in the subform and not treating it as a new
record. Hope this is not confusing. Any brave souls up to the challenge.....

Many thanks to all who reply
Bruce DiPaola

 

[Guest]

if I am reading this right you have a tech with an ID, who deals with
multiple customers doing multiple tasks. You are tracking time and task for
each tech for each customers.
It sounds like you have the master and sub forms linked on the Tech ID
which would bring up any time and tasks associated with the ID selected in
the master.

If you have a customer ID you could link them on instead, then you would
only see the time and task associated with that customer, instead of tech.

hope I this helped