Concatenating in form drop down/combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

-- I need STAT help! I am a newbie and I have a database I that will track
quality improvement criteria. I have a sillie problem (to those more "in the
know"..:-) ).

I have a report (that is bound to a table...i.e. all data will build basic
table/data I need for information being reported on by different
individuals). The very first control is not working right....!!!

It is "Name of Reviewer" which I need to pull down from combo box a list of
names (first and last) to choose from (based on seperate table already
created).

I have tried everything!!

The table has 2 fields..LastName and FirstName. I have tried the
information from Help and this newsgroup on Concatenating...but when I go
back to the form (after trying what I am reading/is suggested)...the drop
down is blank.

Also, before this I was creating a query from RowSource in properties...but
only the first name would appear in the combo box drop down choices (which
obviously has duplicate data based solely on first names).

Help!!! I thought I had this figured out! What am I doing wrong?

TLee

TL/Bonnaroofairy
 
First check your ColumnCount property and your ColumnWidth property. Make
sure that you have as many columns as you expect to show in your SQL
statement and they are set to appropriate widths. (>0")

The concatenation should read something like (subsitute your field and table
names)

Select LastName & ", " & FirstName As FullName From MyTable Order By
LastName;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top