Getting information from Forms

[Chasneey]

I want to setup my own help dialogs in a database I have created.

Each text box has certain data that can be put into it, specified in a table.

I want to be able to click the text box on the form, and to help the user put data in, i want them to be able to hit a button that opens up another form displaying the spec for the data that can be put into that field.

My theory at the moment is use get Focus to somehow select which text box is being used, then somewho append that value into a query which can then be used to reference the table with all the help info in....

Any ideas ??? All answers greatly received !!

[NeoPa]

It might be easier to display in a large TextBox (or even Label) on the same form.
The concept you've laid out should work for you.
Try setting the background colour of the new field to something that differentiates it from the rest.

[Chasneey]

It might be easier to display in a large TextBox (or even Label) on the same form.
The concept you've laid out should work for you.
Try setting the background colour of the new field to something that differentiates it from the rest.

Would that mean having that textbox live all the time ??

I'm getting nearer an answer now.

My current thinking is now to have a query that picks out a property of where focus is on the form.... Just wish i could find a property that does this !!

[NeoPa]

How about the ..._GotFocus event procedures for each item on the form.

You can show a separate form for this if you prefer.
You could have a CheckBox on the main form which showed or hid the other form.