Showing Value Other Than Record ID

  • Thread starter Thread starter Trevor Aiston
  • Start date Start date
T

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
 
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
 
Thanks Tom that worked a treat.

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

Trevor

Tom van Stiphout said:
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
Click to expand...
Click to expand...
 
Thanks Tom that worked a treat.

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

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.
 
Back
Top