sql - combobox.column property returns invalid use of null in vba -
i database//access noob, bear me. have database set keep track of consultants , vendors tech consulting company. consultants own vendors, , have third-party vendors handle contracting. in case consultant own vendor, contact information same both. contact info stored in separate table, primary key contactid , foreign key fields consultantid (primary key in consultantt) , vendorid (primary key in vendort). in case relevant contact info has been entered on 1 of forms, want able select existing contact info record , tell database add other foreign key id field existing record based on record on main form. so, example, if have entered contact info consultant via consultant form, when open vendor form add consultant a's vendor want option select "consultant a" combo box , have info populate vendorsf's contact info form while adding vendorid existing contact info record consultant a. i think i've worked out, stuck on 1 last thing. right have popup form (choosecon...