W
Weezie1383
Oh boy!!
I have created a data entry form which is composed of the main form and 3
subforms. My main form is where people enter information about a document
(e.g. document number, title etc). The subforms all contain information which
relate to the document specified in the main form (e.g. what media it exists
in, what revision it is at). Unfortunately, all of these subforms write to
linking (or junction) tables which are dependant on the document number
entered on the main form. The subforms contain combo boxes used to then
choose the appropriate document number from the list.
The only problem is that it doesn't work!!
What I want to be able to do is after someone types in the document number
in the main form, hence writing to my document table, I want the SQL
statement sitting behind my 3 subforms to run to update the information so
that the current document number will display on the drop-down combo box
list.
Any ideas??
P.S. If anyone knows of a better way to write to multiple tables which are
dependant on each other I would love to know!!!
I have created a data entry form which is composed of the main form and 3
subforms. My main form is where people enter information about a document
(e.g. document number, title etc). The subforms all contain information which
relate to the document specified in the main form (e.g. what media it exists
in, what revision it is at). Unfortunately, all of these subforms write to
linking (or junction) tables which are dependant on the document number
entered on the main form. The subforms contain combo boxes used to then
choose the appropriate document number from the list.
The only problem is that it doesn't work!!
What I want to be able to do is after someone types in the document number
in the main form, hence writing to my document table, I want the SQL
statement sitting behind my 3 subforms to run to update the information so
that the current document number will display on the drop-down combo box
list.
Any ideas??
P.S. If anyone knows of a better way to write to multiple tables which are
dependant on each other I would love to know!!!