Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I get the Field name for a query

Status
Not open for further replies.

sto

Programmer
Nov 26, 2001
14
US
I am currently working on a project that requires a text box to pop up when a key is press in a form that is tied to the active field name. Much like a help popup but built around a table in Access. Any Ideas on getting the field name as a search criteria for the table.
 
Can you explain this a little better.. sorry... think I'm following, but not 100% sure
 
I know that [FieldName].ControlSource will give you the field name that a text box is attached to, but I haven't tried it where the field can be one of any on a form like you're asking. I do know that Me.ActiveControl.ControlSource does NOT work.

Sorry I couldn't be of more assistance.

Kyle
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top