I am using a form to allow users to dynamically set criteria for a report. I have a combobox that displays a field list from the tblMasterFacilityTable. I need the 2nd combobox to be populated with the values from the field chosen i.e. Values from the TxtFacilityType field should be H,CAH,SpH,VA,IHS. I can't seem to get the second combobox to work. I have tried to use a query and also code but I'm lost :-(

Hi
Welcome to Utter Access Forums

What you need is some help in creating what's called "cascading combos" where one combo is driven by another..
Here is a link that will give you some assistance: How can I filter one Microsoft Access combobox based on another combobox selection?.
One of the more common mistakes made is not giving the second combo a Requery after the selection is made from the first combo..

I've had good luck doing the cascading combo boxes before. I may be making this harder than it should be let me go further;
I am having trouble getting the select statement to work because the "field name" value can change each time. Here's what I have

Dim x As String
Dim strSql As String
' I am using the this line because txtText10 is a combox box that displays a field list from the
tbleMaster_facility_table

x = Me.Text10
strSql = "select " & x & " from tbleMaster_facility_table"
txTtext20.rowsource=strSql
txtText20.requery

Unforunately I am not getting anything

I forgot to mention that when I look at the properties on the form anfter I make a change in the first combo box the rowsource reads leterally "select [the correct field name] from tbleMaster_facility_table" (without the quotes) but the combo box remains empty ????

If only I would learn to spell things corectly :-)
Thanks for your reply and it works. I even got it to limit the list to distinct values.
I love this forum

Hi
You're welcome..