 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Use table for textbox list values?
I have developed a form in Access 2003. When entering data using the form, I need to be able to use a dropdown selection of values for a field on the form. I have created the textbox and used its source property to select the table name that contains the values for selection. However, whenever I activiate the form I get the error message "#NAME?". What am I doing wrong? phmckeeve You need more than the table name. You can build a query and use it's name or copy the SQL of the query and paste it with an equal sign preceeding the SQL statement.  SignatureKARL DEWEY Build a little - Test a little > I have developed a form in Access 2003. When entering data using the form, I > need to be able to use a dropdown selection of values for a field on the form. [quoted text clipped - 6 lines] > > phmckeeve OK; I understand what you are saying; but, the table name is "status" with one column that stores the values of approved, cancelled, or rejected. I need to be able to select from these three value in the field on the form. Using the table name to create the expression should accomplish this, right? Well, I get the #NAME? error. So again, what am I doing wrong? phmckeever > You need more than the table name. You can build a query and use it's name > or copy the SQL of the query and paste it with an equal sign preceeding the [quoted text clipped - 10 lines] > > > > phmckeeve In Row Source enter like this --- SELECT ALPHA.ALPHA FROM ALPHA; using your table and field names instead of ALPHA. SignatureKARL DEWEY Build a little - Test a little > OK; I understand what you are saying; but, the table name is "status" with > one column that stores the values of approved, cancelled, or rejected. I [quoted text clipped - 20 lines] > > > > > > phmckeeve Well, Karl, now you have complete lost me. I have a FORM with a textbox I have a Table that has three values in it - approved, cancelled, and rejected. In the CONTROL SOURCE property of the text box, I enter the name of the table with three values. This is suppose to make the values available for data entry on the form; however, I get the #NAME? error, what am I doing wrong; this is suppose to work; please don't give me another way of doing it. If you can't please let someone else answer. Thank you in advance. phmckeever > In Row Source enter like this --- > SELECT ALPHA.ALPHA FROM ALPHA; [quoted text clipped - 24 lines] > > > > > > > > phmckeeve >>I get the #NAME? error Access does not recognize the source name you supplied. Your form should have a Record Source of a table or a query that pulls records from a table. Each textbox should be bound to a field of that table to be able to read data, edit data, and to ad new records. To be able to use a dropdown selection of values for a field on the form you need a Lostbox or a Combobox instead of a Textbox. The listbox would have the field as Control Source and then your Status table as Row Source as mentioned in past post. You want to have Column Count of 1, Column Heads No, Column Widths based on how wide it takes to display your status, and Bound Column 1. SignatureKARL DEWEY Build a little - Test a little > Well, Karl, now you have complete lost me. > [quoted text clipped - 39 lines] > > > > > > > > > > phmckeeve "The listbox would have "the field" as Control Source" What Field??????????? "then your Status table as Row Source as mentioned in past post." Row Source in what controls properties????????????? Your responses to me a too vague; you will have to spell it out. Would you please, please, please enumerate the steps you are talking about. I have told you, I have a form and I want to have a list of values available to the field on the form. PLEASE SPELL IT OUT!!!!!!!!!!!!!!!!! phmckeever > >>I get the #NAME? error > Access does not recognize the source name you supplied. [quoted text clipped - 53 lines] > > > > > > > > > > > > phmckeeve FIGURED IT OUT; > >>I get the #NAME? error > Access does not recognize the source name you supplied. [quoted text clipped - 53 lines] > > > > > > > > > > > > phmckeeve |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.