Showing Value Other Than Record ID

[Trevor Aiston]

I have a subform which has a combobox with the following properties
SELECT [ContactsAuditTrainingEvent Query].ContactID,
[ContactsAuditTrainingEvent Query].FullName
FROM [ContactsAuditTrainingEvent Query];
I want the subform to 'store' the ContactID, but 'display' the full name to
make it easier to use but can't figure out how to do it.


Any ideas?
TIA
Trevor

 

[Tom van Stiphout]

On Sun, 14 Dec 2008 08:36:01 -0800, Trevor Aiston

Set these properties:
RowSource=<your select statement>
RowSourceType=Table/Query
ColumnCount=2
ColumnWidths = "0;1"
BoundColumn=1

The ControlSource should be set to the field in the table where you
want to store ContactID.

-Tom.
Microsoft Access MVP

 

[Trevor Aiston]

Thanks Tom that worked a treat.

Does that come from experience or have I missed someting in a help
file/manual?

Trevor

On Sun, 14 Dec 2008 08:36:01 -0800, Trevor Aiston

Set these properties:
RowSource=<your select statement>
RowSourceType=Table/Query
ColumnCount=2
ColumnWidths = "0;1"
BoundColumn=1

The ControlSource should be set to the field in the table where you
want to store ContactID.

-Tom.
Microsoft Access MVP

I have a subform which has a combobox with the following properties
SELECT [ContactsAuditTrainingEvent Query].ContactID,
[ContactsAuditTrainingEvent Query].FullName
FROM [ContactsAuditTrainingEvent Query];
I want the subform to 'store' the ContactID, but 'display' the full name to
make it easier to use but can't figure out how to do it.


Any ideas?
TIA
Trevor

 

[Rick Brandt]

Thanks Tom that worked a treat.

Does that come from experience or have I missed someting in a help
file/manual?

Don't take this the wrong way, but in a basic Access class that concept
would be covered before lunch on the first day. It is THE basic usage of
a ComboBox. It is how the ComboBox wizard sets things up automatically
if you choose the defaults.