combo box

  • Thread starter Thread starter okiebound
  • Start date Start date
O

okiebound

I added a combo box on a form based on tblAssigned that
draws from tblPersonnel. I want to be able to draw from
tblPersonnel the names that a particular asset was
transferred from. Since the tblPersonnel has two fields
showing LastName and also FirstName how do I combine
these to show both. I don't want to solely use the
PersonnelID number. When I set it up with the wizard
showing the two fields it only applies one. What am I
doing wrong. In advance, thanks
 
Base your combobox on a query and put the following expression in one of the
fields:
AssetAssignee:[FirstName] & " " & [LastName]
 
Little confused (due to my inexperience). Do I need to
add another field to tblPersonnel with fieldAssetAssignee
and use the expression you stated?
Thanks
-----Original Message-----
Base your combobox on a query and put the following expression in one of the
fields:
AssetAssignee:[FirstName] & " " & [LastName]


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com



okiebound said:
I added a combo box on a form based on tblAssigned that
draws from tblPersonnel. I want to be able to draw from
tblPersonnel the names that a particular asset was
transferred from. Since the tblPersonnel has two fields
showing LastName and also FirstName how do I combine
these to show both. I don't want to solely use the
PersonnelID number. When I set it up with the wizard
showing the two fields it only applies one. What am I
doing wrong. In advance, thanks
Click to expand...


.
Click to expand...
 
No. Create a new query in design view. Add your table to the query. Add to
the query grid all the fields from the table that you want to show in the
combo box. Go to the first empty column and type the expression that
PCDatasheet gave you into the "Fields:" cell. Save and close the query.

Then change your combo box's RowSource to be this query instead of your
table.

--

Ken Snell
<MS ACCESS MVP>

okiebound said:
Little confused (due to my inexperience). Do I need to
add another field to tblPersonnel with fieldAssetAssignee
and use the expression you stated?
Thanks
-----Original Message-----
Base your combobox on a query and put the following expression in one of the
fields:
AssetAssignee:[FirstName] & " " & [LastName]


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com



okiebound said:
I added a combo box on a form based on tblAssigned that
draws from tblPersonnel. I want to be able to draw from
tblPersonnel the names that a particular asset was
transferred from. Since the tblPersonnel has two fields
showing LastName and also FirstName how do I combine
these to show both. I don't want to solely use the
PersonnelID number. When I set it up with the wizard
showing the two fields it only applies one. What am I
doing wrong. In advance, thanks
Click to expand...


.
Click to expand...
Click to expand...
 
Got it! Thank you all for your help and patience.
-----Original Message-----
No. Create a new query in design view. Add your table to the query. Add to
the query grid all the fields from the table that you want to show in the
combo box. Go to the first empty column and type the expression that
PCDatasheet gave you into the "Fields:" cell. Save and close the query.

Then change your combo box's RowSource to be this query instead of your
table.

--

Ken Snell
<MS ACCESS MVP>

okiebound said:
Little confused (due to my inexperience). Do I need to
add another field to tblPersonnel with fieldAssetAssignee
and use the expression you stated?
Thanks
-----Original Message-----
Base your combobox on a query and put the following expression in one of the
fields:
AssetAssignee:[FirstName] & " " & [LastName]


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com



I added a combo box on a form based on tblAssigned that
draws from tblPersonnel. I want to be able to draw from
tblPersonnel the names that a particular asset was
transferred from. Since the tblPersonnel has two fields
showing LastName and also FirstName how do I combine
these to show both. I don't want to solely use the
PersonnelID number. When I set it up with the wizard
showing the two fields it only applies one. What am I
doing wrong. In advance, thanks


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top