Record Source Type Problem

[BrianH]

Hi!

I am creating an Access 2000 form in which the user selects the field
from a combo box and then a query will display the selected field from
an already designated table. That's it. I can't seem to figure it
out. I have the combo box with a 'Field List' Record Source Type and
the Record Source is one of my tables. Why won't this work??? When I
try to get the query to run and show the complete field that was just
selected it won't work. I have tried using criteria expressions like
Forms!FormName!COmboBoxName and this doens;t work either.

HELP!!!!

If anyone can help me out it will be greatly appreciated.

Thanks in advance for your time.


~Brian

 

[RuralGuy]

Hi!

I am creating an Access 2000 form in which the user selects the field
from a combo box and then a query will display the selected field from
an already designated table. That's it. I can't seem to figure it
out. I have the combo box with a 'Field List' Record Source Type and
the Record Source is one of my tables. Why won't this work??? When I
try to get the query to run and show the complete field that was just
selected it won't work. I have tried using criteria expressions like
Forms!FormName!COmboBoxName and this doens;t work either.

HELP!!!!

If anyone can help me out it will be greatly appreciated.

Thanks in advance for your time.


~Brian

Your Row Source Type should be Table/Query, *not* Field List
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.