Datasheet Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Main Form and a SubForm (which is in Datasheet view).

When I move from the MainFrm into the SubFrm - the first row acts
unpredictably. Upon beginning to enter a record it returns the error message
" You cannot assign a value to this object". If I over-ride the error
message it accepts the entry.
Subsequent rows respond OK, picking up linkages from the MainFrm, but the
1st row does not pick up the linkages (mainly via the 'Default' property)

How can I prevent the 1st row of the Datasheet behaving in this odd manner?
 
Make sure that the master/child links are properly set. What code do you
have that runs when the subform gets focus or in the subform's Current
event? Your own code is probably causing the problem.
 
Thanks Pat - I think it was my Parent/Child linkage. I had it linked using
the 'ID' only. I changed it so that the 5 fields of the Parent are linked to
the corresponding fields in the Child.
The problem dissappeared - I'm not sure that I understand why, but 'if it
ain't broke don't fix it'.
 
Back
Top