Form/Subform

  • Thread starter Thread starter DrGUI
  • Start date Start date
D

DrGUI

I have a Form/Subform problem. in the Main form, I have a
list box with a one-2-many realationship with the
subform. The child/master link is properly set. when I
select an item in the list box, the subform displays the
correct records. The problem is when I try to add a new
record in the subform. After typing in a few characters
into the new record in the subform, the subform
automatically highlights the characters that I currently
have typed in and refreshes/resorts the records. It is
not letting me finish typing in the new value for the
field. There is no event handler in the forms. WHat
gives? Anyone else encounter this sort of thing????
 
Is the RecordSource of the subform a query that contains 2 or more tables?

If so, there is an issue that is triggered by the presence of a Default
Value in the table you are NOT adding the new record to. Access
misinterprets this, and tries to apply the DefaultValue to the field from
the other table, which fails, and the result is behavior similar to what you
describe.

Try removing the Default Value from the fields in the table, and also from
the text boxes in the form.
 
Back
Top