J
Joe
Hi,
I've got two tables: MAIN & VENDORS
VENDORS is linked to the MAIN table where MAIN is on the
one side and VENDORS is on the many side.
The "INDEX" field is the primary field on the MAIN table.
Which is linked to the "CustomerID" field in the VENDORS
table.
I don't know if this is the correct set up because here's
my problem:
The VENDORS form is setup with an unbound combo box that
selects a vendor by name. Then fills in the other bound
text boxes.
I'm using a Macro to find a record to do this. And it
works ok as a stand alone form (frmVENDORS).
But when I make the frmVendors form a subform of the MAIN
form (frmMAIN) It won't let me select a new customer.
Probably because It's trying to change a record that's
already open.
Am I going about this whole thing wrong?
How do you properly join two tables, then combine them
onto one form, while still being able to make new
selections for the subform?
Some examples might help me figure out what to do.
Thanks,
Joe
I've got two tables: MAIN & VENDORS
VENDORS is linked to the MAIN table where MAIN is on the
one side and VENDORS is on the many side.
The "INDEX" field is the primary field on the MAIN table.
Which is linked to the "CustomerID" field in the VENDORS
table.
I don't know if this is the correct set up because here's
my problem:
The VENDORS form is setup with an unbound combo box that
selects a vendor by name. Then fills in the other bound
text boxes.
I'm using a Macro to find a record to do this. And it
works ok as a stand alone form (frmVENDORS).
But when I make the frmVendors form a subform of the MAIN
form (frmMAIN) It won't let me select a new customer.
Probably because It's trying to change a record that's
already open.
Am I going about this whole thing wrong?
How do you properly join two tables, then combine them
onto one form, while still being able to make new
selections for the subform?
Some examples might help me figure out what to do.
Thanks,
Joe