Combo Box Row Source question 1

[daglugub37]

I am using a the following rowsource for tblRosters.fldPlayerID where I am trying to Input football players onto a team's roster.

SELECT [tblPlayers].[fldFirst], [tblPlayers].[fldLast], [tblPlayers].[fldPosition], [tblPlayers].[fldPlayerID] FROM tblPlayers;

Bound Column = 4
Column Count = 4
Column Heads = No
Column Widths = {BLANK}
List Rows = 8
List Width = Auto
Limit to List = Yes



The problem I am having is data entry related. For example(s) when I try to input players via datasheet view here is how the combo box looks to me.

John | Smith | QB
Kevin | Lee | HB

Lets say I wanted John Smith... so I select that entry for the new record...only "John" displays.

Now Lets Say I wanted to add "John Taylor"...it won't work...the only selection available to me is the first match which was John Smith.

What am I doing wrong?

 

[KenReay]

Hi

SELECT [tblPlayers].[fldPlayerID],[tblPlayers].[fldFirst], [tblPlayers].[fldLast], [tblPlayers].[fldPosition] FROM tblPlayers;

Bound Column = 1
Column Count = 4
Column Heads = No
Column Widths = 0;3;3;3
List Rows = 8
List Width = 9
Limit to List = Yes

I am assuming units of Centimetres, you may nned to adjust the widths, particulalrly if you are using inches


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[daglugub37]

Hi Ken,

unfortunately this results in the same problem...the value list is not showing up like

Jeff Smith QB
Greg Peters HB

instead it looks like
Jeff | Smith | QB
Greg | Peters | HB

now this is disallowing me from typing in names and the auto-complete function will not go past the first field. Technically the table is functional but I have to scroll through thousands of records to find the player I want to input.

Obviously I don't know what i am doing but don't I need something like this.

SELECT [tblPlayers].[fldPlayerID],[tblPlayers].[fldFirst], [tblPlayers].[fldLast], [tblPlayers].[fldPosition] AS Name FROM tblPlayers;

and then somehow use the Name column for my row source?

 

[daglugub37]

KenReay

I figured it out...i went with

SELECT [tblPlayers].[fldPlayerID], [tblPlayers].[fldFirst]+" "+[tblPlayers].[fldLast]+" - "+[tblPlayers].[fldPosition] AS Name FROM tblPlayers;

Bound Column = 1
Column Count = 2
Column Heads = No
Column Widths = 0;5
List Rows = 8
List Width = 5
Limit to List = Yes

Thanks for your help on the above properties, I now have a better understanding of what they do