Hi all,
I ran into an issue with a subform that's twisting my brain a bit, I'm sure it's some obnoxiously simple thing but I'm lost:
- I have a form with a subform. The form contains information about components drawn from tblMasterParts and the subform contains information about vendors and pricing drawn from a junction table, tblVNDPRTS, which is in turn connected to tblVendors
- I have a field in the subform, VendorName, whose rowsource is tblVendors and control source is VendorName (The name of the control on the subform as well as a field in tblVendors)
- The combobox for VendorName, when assigned no rowsource displays nothing. To be expected. When I change the rowsource to tblVendors I get the Vendor_ID numbers in the combobox instead of the VendorName entries.
Attached are the relationship diagram and a snip of the form in design view with properties open. Let me know if I can provide more info. Any ideas will help, I'm stumped after trying (And searching) all morning.