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.

What you can do is to put the help text in the Tag property of the control then when the control gets the focus you pass this string to the help text control.
Me.HelpText = Me.ActiveControl.Tag

David

__________________
www.xcraftlimited.co.uk The Home of Simple Software Solutions.

Yes i looked at something like this, but the help is often several lines long (with line breaks and examples). I really want to be able to edit the helptext in a table (through a form).

Not really solved as such, but found an alternative. I've used HelpMaker to actually make a .hlp help file.