#error in subform field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PHisaw - 10 May 2007 19:24 GMT

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

Reply to this Message

Ofer Cohen - 10 May 2007 19:36 GMT

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

Signature

Good Luck
BS"D

> I have a datasheet subform "MaintenanceSubform" based on the following query:
>
[quoted text clipped - 18 lines]
> Thanks in advance,
> Pam

Reply to this Message

PHisaw - 10 May 2007 20:46 GMT

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

> Mybe,
>
[quoted text clipped - 32 lines]
> > Thanks in advance,
> > Pam

Reply to this Message