Travis- You have told the combo box you have only one column, but you have defined column widths for two columns. Is the first column in tblSegmentRSM a number? If so, it should set the bound column with no problems. What are the first two columns in the table?
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Travis Simons Sent: Monday, January 23, 2006 8:55 PM To: [email protected] Subject: RE: [ms_access] Access Limit to List problem. What are the following properties of your combo box? Row Source: tblSegmentRSM Column Count: 1 Column Widths: 8"; 5" Bound Column: 1 And what is the data type of the Control Source? Number (of the 'segmentRSMID" primary key) -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, January 23, 2006 6:06 PM To: [email protected] Subject: RE: [ms_access] Access Limit to List problem. Travis- What are the following properties of your combo box? Row Source: (the SQL if a query) Column Count: Column Widths: Bound Column: And what is the data type of the Control Source? John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Travis Simons Sent: Monday, January 23, 2006 5:55 PM To: [email protected] Subject: [ms_access] Access Limit to List problem. I'm having problems with my main table which a field is linked to another table which I'm trying to "not limit to list". When I go to create the field on the form it displays a number and not the name of the person. I have tried changing the columns widths and no luck. Here is the error that I'm getting. The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is longer than the field size setting permits. [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
