One Table - Two ComboBoxes - Populate and edit linked fields of each

L

larpup

Thanks to Allen Browne, he explained how to have two Comboboxes on one
form linked to one table using an alias. The Cbo's work perfectly.

My problem is that the linked fields to each combobox need be edited.
The fields linked to the first cbo are no problem, the second however
is. I realized I can populate with the column(#) property or DLookup
for that matter, but that will not allow editing of the linked fields
to the second CBO.

Example
ShipperName = 1st Cbo
address (can be edited)
city
state

ConsigneeName = 2nd Cbo
address
city
state

Is there anyway I can use one table and still edit the fields linked to
the second Cbo?


Lar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top