A
Allen B via AccessMonster.com
I have 2 subforms on my main form. subform1 is linked to my comboBox
dropdown. When I pick a vendor from the drop-down subform1 fills with all
the custom info for that vendor.
Subform2 should also fill with a date text field for the user to fill in.
But I can't get subform2 to list the date field next to each custom info
field.
In my query the subform1 table has companyid which is tied/linked back to the
mainform drop-down vendor list.
In my query the subform2 table has companyid, custom info, date which i need
to tie to subform 1
example of how the subforms should look below:
from combo drop-down I picked vendor #1
subform 1 subform2 (user types in the
date or leaves blank)
companyid custom info dateRec'd custom info
companyid
1 west coast form 5/12/2005 west coast
form 1
1 east pkg generic east
pkg generic 1
If I chose another vendor the list may have 5 or as many as 20 custom info
which I need the dateRec'd field in subform2 to populate with 5 or as many as
20 rows along with subform1.
if subform1 has 5 rows of info, then subform2 should have 5 rows of dateRec'd
to be completed by the User.
To maybe better explain what I'm trying to do...... I have loaded in a table
custom information for all the vendors. When I click on the vendor drop-down
on the main form, the subform1 populates with all the custom information
requirements for that vendor. The User then needs enter data in subform2 if
that custom requirement has been received.
What makes the record in the event table (which is tied to subform2) unique
is the JO#. What makes the record unique in the custom info table (for
subform1) is the company id. The custom info table never gets updated,
because this list will be used for many different JO#'s. However the event
table will be updated with as many custom info records for each JO#. This
event table is the detail table.
Can anyone help me on this one?
Thanks, Allen
dropdown. When I pick a vendor from the drop-down subform1 fills with all
the custom info for that vendor.
Subform2 should also fill with a date text field for the user to fill in.
But I can't get subform2 to list the date field next to each custom info
field.
In my query the subform1 table has companyid which is tied/linked back to the
mainform drop-down vendor list.
In my query the subform2 table has companyid, custom info, date which i need
to tie to subform 1
example of how the subforms should look below:
from combo drop-down I picked vendor #1
subform 1 subform2 (user types in the
date or leaves blank)
companyid custom info dateRec'd custom info
companyid
1 west coast form 5/12/2005 west coast
form 1
1 east pkg generic east
pkg generic 1
If I chose another vendor the list may have 5 or as many as 20 custom info
which I need the dateRec'd field in subform2 to populate with 5 or as many as
20 rows along with subform1.
if subform1 has 5 rows of info, then subform2 should have 5 rows of dateRec'd
to be completed by the User.
To maybe better explain what I'm trying to do...... I have loaded in a table
custom information for all the vendors. When I click on the vendor drop-down
on the main form, the subform1 populates with all the custom information
requirements for that vendor. The User then needs enter data in subform2 if
that custom requirement has been received.
What makes the record in the event table (which is tied to subform2) unique
is the JO#. What makes the record unique in the custom info table (for
subform1) is the company id. The custom info table never gets updated,
because this list will be used for many different JO#'s. However the event
table will be updated with as many custom info records for each JO#. This
event table is the detail table.
Can anyone help me on this one?
Thanks, Allen