If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Concatenating in form drop down/combo box
-- 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 |
#2
|
|||
|
|||
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 "bonnaroofairy" wrote in message ... -- 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Autopopulating a form field from a drop down form field | Shannon | General Discussion | 12 | March 24th, 2008 07:05 PM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
Drop Down Box on a Form | Frank | Using Forms | 4 | June 18th, 2004 03:22 PM |
How to syncronize a datasheet form and single form? | Sandra | Using Forms | 9 | June 16th, 2004 05:24 AM |