Single record subform misbehaves...

  • Thread starter Thread starter Hieron
  • Start date Start date
H

Hieron

Hi all,

I have been working on a few Access 2000 databases for the last few
weeks, I think I am still scratching the surface.

I have a main form and there are four subforms displayed on it.

Three of the subforms are placed on a tab control frame, and they are
continuous forms.

The Customer form is a single record form.

They work fine displaying the data already in the tables, however, when
I create a new record, nothing is seen in the place where the Customer
subform should appear, so I cannot enter any data (name, address, etc).

I am sure there is a way around, and I would greatly appreciate if you
could help.
 
They work fine displaying the data already in the tables, however, when
I create a new record, nothing is seen in the place where the Customer
subform should appear, so I cannot enter any data (name, address, etc).
Click to expand...

It sounds like the form you're using in the Customer subform, or the
query upon which that form is based, is not updateable. Check the
Allow Updates property of the Form; if the form is based on a Query,
see if you can open that query in datasheet view and add a new record.
If you cannot, check the online help for "updatable query" or post the
SQL view of the query here.

John W. Vinson[MVP]
 
John said:
It sounds like the form you're using in the Customer subform, or the
query upon which that form is based, is not updateable. Check the
Allow Updates property of the Form; if the form is based on a Query,
see if you can open that query in datasheet view and add a new record.
If you cannot, check the online help for "updatable query" or post the
SQL view of the query here.

John W. Vinson[MVP]
Click to expand...

It is updateable, I checked it.

Here is the script:

SELECT [Customer].[Customer Name], [Customer].[Customer Phone Number],
[Customer].[Street Address], [Customer].[Suburb], [Customer].[State],
[Customer].[Postcode], [Customer].[ID] FROM Customer GROUP BY
[Customer].[Customer Name], [Customer].[Customer Phone Number],
[Customer].[Street Address], [Customer].[Suburb], [Customer].[State],
[Customer].[Postcode], [Customer].[ID];

The Parent - Child relationship is set in the subform property settings
correctly. All data is displayed correctly as I go through the records,
but when I create a new record, the Customer subform becomes blank.
 
SELECT [Customer].[Customer Name], [Customer].[Customer Phone Number],
[Customer].[Street Address], [Customer].[Suburb], [Customer].[State],
[Customer].[Postcode], [Customer].[ID] FROM Customer GROUP BY
[Customer].[Customer Name], [Customer].[Customer Phone Number],
[Customer].[Street Address], [Customer].[Suburb], [Customer].[State],
[Customer].[Postcode], [Customer].[ID];
Click to expand...

That's not updateable and CANNOT be updateable - it's got a Group By,
and no Group query is ever updateable.

Unclick the Greek Sigma icaon or remove the Group By clause (which is
doing you harm and no good).

John W. Vinson[MVP]
 
John said:
SELECT [Customer].[Customer Name], [Customer].[Customer Phone Number],
[Customer].[Street Address], [Customer].[Suburb], [Customer].[State],
[Customer].[Postcode], [Customer].[ID] FROM Customer GROUP BY
[Customer].[Customer Name], [Customer].[Customer Phone Number],
[Customer].[Street Address], [Customer].[Suburb], [Customer].[State],
[Customer].[Postcode], [Customer].[ID];
Click to expand...


That's not updateable and CANNOT be updateable - it's got a Group By,
and no Group query is ever updateable.

Unclick the Greek Sigma icaon or remove the Group By clause (which is
doing you harm and no good).

John W. Vinson[MVP]
Click to expand...

I removed the Group By clause, and now the query displays nothing at all.
 
John said:
SELECT [Customer].[Customer Name], [Customer].[Customer Phone Number],
[Customer].[Street Address], [Customer].[Suburb], [Customer].[State],
[Customer].[Postcode], [Customer].[ID] FROM Customer GROUP BY
[Customer].[Customer Name], [Customer].[Customer Phone Number],
[Customer].[Street Address], [Customer].[Suburb], [Customer].[State],
[Customer].[Postcode], [Customer].[ID];
Click to expand...


That's not updateable and CANNOT be updateable - it's got a Group By,
and no Group query is ever updateable.

Unclick the Greek Sigma icaon or remove the Group By clause (which is
doing you harm and no good).

John W. Vinson[MVP]
Click to expand...


I mean on the form.
 
I mean on the form.
Click to expand...

I'm sorry, Hieron, I have no idea what you mean. WHAT on the form?

Please post the SQL view of the current subform's Recordsource.


John W. Vinson[MVP]
 
Back
Top