C
Chris Strug
Hi,
I'm having a spot of bother with a sub-form.
Simple enough: main form displays customer details, sub form displays
customer charges. Forms linked through customer ID.
Forms display information fine - the problem is when inserting data into the
subform the error message below appears:
"The data was added to the database but the data was won't be displayed in
the form because it doesn't satisfy the criteria in the underlying
recordsource."
And accordingly the data doesn't appear, although it does if you exist and
re-enter the form.
The only thing I can think of is that the customer_ID is not being inserted
into the sub-form's new record so that the relationship isn't recognised
until the form is reloaded.
However I have never had this problem before (admittedly I don't use sub
forms a great deal) and after checking everything I can think of I'm
stumped.
I'm using access 2000 with an ADP linked to SQL Server 2000 if that makes
any difference...
Can anyone provide any pointers as to what is going on and the approach I
need to solve it?
Any and all advice is gratefully received.
Kind thanks
Chris Strug
I'm having a spot of bother with a sub-form.
Simple enough: main form displays customer details, sub form displays
customer charges. Forms linked through customer ID.
Forms display information fine - the problem is when inserting data into the
subform the error message below appears:
"The data was added to the database but the data was won't be displayed in
the form because it doesn't satisfy the criteria in the underlying
recordsource."
And accordingly the data doesn't appear, although it does if you exist and
re-enter the form.
The only thing I can think of is that the customer_ID is not being inserted
into the sub-form's new record so that the relationship isn't recognised
until the form is reloaded.
However I have never had this problem before (admittedly I don't use sub
forms a great deal) and after checking everything I can think of I'm
stumped.
I'm using access 2000 with an ADP linked to SQL Server 2000 if that makes
any difference...
Can anyone provide any pointers as to what is going on and the approach I
need to solve it?
Any and all advice is gratefully received.
Kind thanks
Chris Strug