I have a form (frmBooks) with several fields, one of which is an unbound textbox (txtHelpText).
As each field in the form gets the focus, the text in txtHelpText changes to show relevant help. At the moment this is done through the OnFocus event code.
This makes it difficult to edit the help text as it means hunting through the code.
I'd like to have a table (tblHelpText) with two fields (ID & HelpText). Then as each field on frmBooks gets the focus, have the contents of txtHelpText pick up the relevant data from [tblHelpText].[HelpText].
Only problem is, i've no idea how to go about it. I'm only vba beginner really.
Thanks in advance.