SELECT TOP Query in a Form

[Pascal]

Hi

I have a large table with many records. In a Form I set in Form_open
following Code:

Me.RecordSource = "SELECT TOP 10 BIG_TABLE.* FROM BIG_TABLE"

Everything seems to be ok, 10 records are in the form.

But if I want add a new record, there is a Problem to save the new record.
In the form every field are contains #deleted

The same problem appear if i set the recordsource with a where clause.

Why I can't add a new record?

thanks
Pascal

 

[John W. Vinson]

Hi

I have a large table with many records. In a Form I set in Form_open
following Code:

Me.RecordSource = "SELECT TOP 10 BIG_TABLE.* FROM BIG_TABLE"

Everything seems to be ok, 10 records are in the form.

But if I want add a new record, there is a Problem to save the new record.
In the form every field are contains #deleted

The same problem appear if i set the recordsource with a where clause.

Why I can't add a new record?

Because a Top Values query is not updateable, and cannot be made updateable.

 

[John Spencer]

John,

I just created a top 10 query and was able to add records to it. Why do
you say a Top 10 query is not updateable?

Just to make sure I created a form (Continous) based on a TOP 10 query
and was also able to add records to it.

To the poster, I'm not able to figure out what is causing your problem.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[John W. Vinson]

John,

I just created a top 10 query and was able to add records to it. Why do
you say a Top 10 query is not updateable?

eeep!

SORRY to all in this thread... I was thinking of a Group By query.