AUTOMATICALLY FILLING IN CAUSING ERRORS

[Angelique]

Once again I have a problem that I have spent some days working on.

I have a form that consists of one (1) Main and two (2) subforms. The link field for both subforms is QClientID.

The Main form works great until I code it to do automatic fillin of the main fields e.g. Name, Address, Phone etc. The process used is similar to the Orders.db wherein I use a query 1:M relationship for the form and a sorted Client query for the combo box displaying the Clien Names.

When I select a different client to the one displayed, it accepts the Client Name but nothing else happens! the automatic fillin does appear to happen.

As I navigate through the records, I get a error message:

"The LinkMasterFields property setting produced this error. "Member already exists in object module from which this object derives".

Does anyone know what is causing this? After the message, the form displays the info. Unfortunately, Access decided to spit the dummy and a reboot was necessary.

HELP!!! This form is going to be used by people who HATE typing, your worse nightmare and I need to get it functional soon.

Angelique

 

[Francescina]

In case that your problem persists:

I fear that your problem is too complex and exceeds the frame of the forum. If you still need assistance you can send me your problematic form via e-mail: msACCESSTEAM@Hotmail.com.

Fran

 

[Angelique]

Dear Fran,

I had to do something, seemed like I had a difficult one on my hands and the user wanted results.

I looked at my form and the tables and through process of elimination, discovered that the referencing on QClient several times on the form was giving poor Access a headache. Once I reduced the form to only having two (2) occurrences of the QClientID to deal with, it appears (hopefully forever) to have resolved the strange error message.

Naturally, you may feel that it is a more serious underlying problem. If so, I will send you an email.

Thanks! I do appreciate your time and energy as I do with all those who assist.

Angelique