data won't be displayed in the form

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

Guest

Server = SQL Server 2000 SP3
Client = Access 2000 SP3 Data Project

Created a form with sub-form in .adp, when a row is added to the main form
it errors, and removes the newly entered form from view.

"The data was added to the database but the data won't be displayed in the
form because it doesn't satisfy the criteria in the underlying record source"

The still exists in the database, as re-opening the form displays the data
as normal.

The record source for the main form is simply Select a,b,c from d left outer
join e on d.a = e.a
The record source for the sub form is simply select j,k from l
There are no filters, no server filters, no form filters, no where clauses.

Google returns just a dozen results, none of which help, has anyone else
come accross this issue?

Thanks.
 
Are you appending the record to a SQL server view?, check the criteria for
the view and make sure the values you are sending using your form meet the
criteria specified in the SQL server view,
 
Thanks for the reply
The source is 1 table, using a left outer join to link to another table (sub
forms source) 2 tables, no views, just to re-iterate:

[ The record source for the main form is simply Select a,b,c from d left outer
join e on d.a = e.a
The record source for the sub form is simply select j,k from l
There are no filters, no server filters, no form filters, no where clauses. ]
 
Check your master and child field links in your sub form, make sure they are
spelled right and the 2 tables have a common field to link,

Steve'o said:
Thanks for the reply
The source is 1 table, using a left outer join to link to another table (sub
forms source) 2 tables, no views, just to re-iterate:

[ The record source for the main form is simply Select a,b,c from d left outer
join e on d.a = e.a
The record source for the sub form is simply select j,k from l
There are no filters, no server filters, no form filters, no where clauses. ]


jl5000 said:
Are you appending the record to a SQL server view?, check the criteria for
the view and make sure the values you are sending using your form meet the
criteria specified in the SQL server view,
Click to expand...
Click to expand...
 
Back
Top