Recordset error with subform (Access 97)

I'm new to Access and hoping someone will be able to point me in the right direction. I've simplified the problem as follows:

I have 2 forms:
MainFormTechnician (displays Tech Number and Tech Name)
SubFormClient (displays Client Number and Client Name)

The relationship is one to many. I created a combo box on the main form, so when a Tech Number is selected, their clients display in the subform.

I also need to do this in reverse ie When a Client Number is selected, their Technician displays.

So I added another combo box to the main form, which contains the Client number. I put some code in the AfterUpdate Event. It works, but then the Tech number combo box fails. I get "Runtime error 2105: You can't go to the specified record. You may be at the end of a recordset." If I then select a value from the Client number combo box, I get "Runtime error 3020: Update or CancelUpdate without AddNew or Edit".

Any help would be much appreciated, as I don't know much about recordsets.

Re: Recordset error with subform (Access 97)

Is the combo box for Tech Number bound to the Tech Number field? That could cause problems (a combo box used to search for a record should not be bound.)

If possible, could you post a stripped down version of the database?
<UL><LI>Make a copy of the database and work with that.
<LI>Remove all database objects (tables, queries, forms, reports, macros and modules) that are not relevant to the problem.
<LI>In the remaining table(s), remove most records - leave only the minimum number necessary to demonstrate the problem.
<LI>Remove or modify data of a confidential nature.
<LI>Do a compact and repair (Tools/Database Utilities).
<LI>Make a zip file containing the database; it should be below 100KB.
<LI>Attach the zip file to a reply.[/list]That would enable Loungers to take a look at the problem directly.

Re: Recordset error with subform (Access 97)

It sounds to me as if you need to have an initial form where you select that you want to view the main form which displays technicians containing a subform of clients or a different main form to display clients with a subform for technicians.