#error in subform field

I have a datasheet subform "MaintenanceSubform" based on the following query:

SELECT Maintenance.MaintenanceID, Maintenance.AssetID,
Maintenance.ComponentID, Maintenance.MaintenanceDate,
Maintenance.MaintenanceDescription, Maintenance.MaintenancePerformedBy
FROM Maintenance;

The "Maintenance" table (many) is joined in a one-to-many relationship with
referential integrity to table "Components" (one) field name "ComponentsID"
(pk). The Maintenance table pk is MaintenanceID.

The MaintenanceSubform is on the Maintenance form which has ComponentsID as
a field also (linking master and child fields). When this form is open the
ComponentsID on the subform has #error in the text box. I can type over
this, but I want it to show automatically based on the componentID from the
main form.

I hope I've explained what is happening and what I want to happen.

Any help is, as always, greatly appreciated.
Thanks in advance,
Pam

Mybe,

You can get an error if the text box is bound to a field that doesn't exist
in the table.
In the SQL the field called

ComponentID

And in your post you wrote that the in the field its written

ComponentsID

You have extra s in it
--
Good Luck
BS"D


"PHisaw" wrote:

I have a datasheet subform "MaintenanceSubform" based on the following query:

SELECT Maintenance.MaintenanceID, Maintenance.AssetID,
Maintenance.ComponentID, Maintenance.MaintenanceDate,
Maintenance.MaintenanceDescription, Maintenance.MaintenancePerformedBy
FROM Maintenance;

The "Maintenance" table (many) is joined in a one-to-many relationship with
referential integrity to table "Components" (one) field name "ComponentsID"
(pk). The Maintenance table pk is MaintenanceID.

The MaintenanceSubform is on the Maintenance form which has ComponentsID as
a field also (linking master and child fields). When this form is open the
ComponentsID on the subform has #error in the text box. I can type over
this, but I want it to show automatically based on the componentID from the
main form.

I hope I've explained what is happening and what I want to happen.

Any help is, as always, greatly appreciated.
Thanks in advance,
Pam

Hi Ofer,

Thanks for the reply. I double checked and the text box is bound to
ComponentID from the table and I typed the name in error in the post - it is
ComponentID.
Do you have any other suggestions?
Thanks again,
Pam

"Ofer Cohen" wrote:

Mybe,

You can get an error if the text box is bound to a field that doesn't exist
in the table.
In the SQL the field called

ComponentID

And in your post you wrote that the in the field its written

ComponentsID

You have extra s in it
--
Good Luck
BS"D


"PHisaw" wrote:

I have a datasheet subform "MaintenanceSubform" based on the following query:

SELECT Maintenance.MaintenanceID, Maintenance.AssetID,
Maintenance.ComponentID, Maintenance.MaintenanceDate,
Maintenance.MaintenanceDescription, Maintenance.MaintenancePerformedBy
FROM Maintenance;

The "Maintenance" table (many) is joined in a one-to-many relationship with
referential integrity to table "Components" (one) field name "ComponentsID"
(pk). The Maintenance table pk is MaintenanceID.

The MaintenanceSubform is on the Maintenance form which has ComponentsID as
a field also (linking master and child fields). When this form is open the
ComponentsID on the subform has #error in the text box. I can type over
this, but I want it to show automatically based on the componentID from the
main form.

I hope I've explained what is happening and what I want to happen.

Any help is, as always, greatly appreciated.
Thanks in advance,
Pam