G
Guest
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
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