Hi all,

I have a form that I use to enter data. I have a combo box set up in the form that uses 3 fields from two tables (LocationID.tblSamplingLocations, Client.tblClients, and SampleLocation.tblSamplingLocations). I have the format of the combo box set up as 3 columns, 0";2"2" to display the Client Name and Sampling Location Name. The idea is that some clients may have sampling locations with the same name (i.e. Outlet 1) so, the combo box shows both the client name and the sample location name to target the correct record in tblSamplingLocations.

This works great when the dropdown is activated, both columns show and it is very clear which selection should be made. But, after selecting an option, is only shows the data from Client.tblClients (the first visable column) in the box, which makes other users think something has gone wrong.

Is there a way to force the combo box to continue showing both columns after a selection has been made, or, alternatively, to have it show just the data from SampleLocation.tblSamplingLocations?

​

Thanks!