Row source from table to form

[cameronaziz]

Im new to access.



I have a form that has a column with a row source of

SELECT [SpecimenTable].[ID], [SpecimenTable].[SpecType] FROM SpecimenTable ORDER BY [ID];

and that works great. It pulls the information and displaces the "spectype" as the choice. When I put that into a form with the same row source, it shows be the ID, not the SpecType as the option.

A work around I have found is deleting the first part and just having

SELECT [SpecimenTable].[SpecType] FROM SpecimenTable ORDER BY [ID];

but then it wont let me actually click on anything. Any advice?

[RuralGuy]

Forms do not have a RowSource, controls do. Are you actually referring to a control and if so, what type of control? ComboBox, List Box, etc.

[cameronaziz]

I mis spoke the first time. I meant to say:

I have a table with a combo box with a row source of


SELECT [SpecimenTable].[ID], [SpecimenTable].[SpecType] FROM SpecimenTable ORDER BY [ID];


Im trying to have that same combo box on a form.

[RuralGuy]

I hate to break the news but you should start by removing the LookupFields from the tables. http://www.mvps.org/access/lookupfields.htm It is just fine to have ComboBoxes on your forms that do basically the same thing, just not at the table level.

[cameronaziz]

Thanks!

So then what is the proper way to do it at the table level?

That being said, on my form, do you know whats wrong with the row source?

[RuralGuy]

So then what is the proper way to do it at the table level?

There is *no* proper way to do this at the table level. It is all done on a form. As for the RowSource of your ComboBox on the form, I see nothing wrong with it. It looks like it should work just fine. Save the RowSource as a query (press the "..." button on that property) and then open the query and see what you get.

[cameronaziz]

messed with the query builder. got it to work with:

SELECT SpecimenTable.SpecType, SpecimenTable.ID FROM SpecimenTable ORDER BY SpecimenTable.ID;

so on my table the proper method would be just to have text data type and nothing else.

Thanks so much, btw!

[RuralGuy]

messed with the query builder. got it to work with:

SELECT SpecimenTable.SpecType, SpecimenTable.ID FROM SpecimenTable ORDER BY SpecimenTable.ID;

It should have also worked with:
SELECT SpecType, ID FROM SpecimenTable ORDER BY ID;

so on my table the proper method would be just to have text data type and nothing else.

TextBoxes in the Lookup tab, YES. The field can be any type of DataType you want.