If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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 |
#2
|
|||
|
|||
#error in subform field
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 |
#3
|
|||
|
|||
#error in subform field
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 |
Thread Tools | |
Display Modes | |
|
|