Master/Child Field

[mewins]

I am having a problem with the master and child fields not saving correctly
to the tables. I have a main form with several subforms, all linked with the
master and child fields “ClientID.†For some reason, my subformCaseNotes
will frequently allow people to enter in data, but when I go to the table,
the data is there but the ClientID is left blank. That is, I can see the
record, it was assigned its autonumberID, but the field for ClientID is
blank. The database has a back end and 2 front ends, with no more than a
dozen people working in it at any given time. I don’t seem to have this
problem with any of my other subforms. It’s a bit of a pressing problem
since subformCaseNotes is used very frequently, and having case notes go
“missing†complicates the work. Is there something wrong in the subform
itself or is it in the table or is it a network problem? The tableCaseNotes
is set to have a random autonumber ID and then the ClientID is set to just be
a number and to link into my tableMainInfo. Any ideas on how to fix this?
Thanks!

 

[Klatuu]

If you are using a query as the subform's record source, the ClientID field
needs to be in the query but it does not have to be bound to a control.

 

[mewins]

The subform does run off a query and the ClientID is in the query. Most of
the time the records save correctly, but occasionally it does not. I know I
have several people in the database at the same time, but they usually are
not editing the same record. Is there anything else I can do to prevent this?

 

[Klatuu]

I don't have any other suggestions, sorry.

 

[mewins]

We have been having some issues with computers connecting to our network at
times. Could this possibly be causing the problem?

 

[Klatuu]

It may be, but I have no way of knowing for sure. You might want to monitor
it to determine when it happens and to whom it is happening.

 

[mewins]

I'm monitoring as best as I can and so far I can't detect a pattern. It
doesn't only happen to certain staff or at certain times of the day or for
certain client records. I have all of the tables timestamp when records are
created, so I can see who was writing the note and when, and there is a lot
of variation for notes that aren't properly saving the ClientID. Is there
another way I can figure this out better?

 

[Klatuu]

I don't really have any other ideas. You might just review your code
carefully and maybe run a session in debug to see if you can find a problem
there.

 

[mewins]

Ok. Thanks for your help!

I don't really have any other ideas. You might just review your code
carefully and maybe run a session in debug to see if you can find a problem
there.