Use table for textbox list values?

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

In Row Source enter like this ---
SELECT ALPHA.ALPHA FROM ALPHA;
using your table and field names instead of ALPHA.

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

"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

 

[Guest]

FIGURED IT OUT;

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.