Bound form with unbound controls

[Jeff]

I have a bound form that has 2 unbound combo boxes that I need to have the
value of combo #2 as a field value of the table the form is bound to.
Haven't worked with ACCESS in a while so my programming is off, but can
anyone help me out here?

Thanks,

Jeff

 

[Jack Leach]

This is an odd request. May I ask why you need an unbound control that has a
value from the same table that the form is bound to? Do you mean field name
maybe?

To get a value (though I don't know why you would in this case), use:
=DLookup("Fieldname", "Tablename", "Criteria")

If you're thinking the name of the field... I'm not sure how you can get it.
You could always loop the TableDef collection for this type of
information... except you will need to know the field name (or it's index),
so it's a bit of a moot point.

hth


--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)