Open Form and Find Record based on Control Source of Main Form

[mous]

Hi

Using Access 2003.

I have a Form, from which I have a "Help" subform (opens using double-click of field) that identifies the field name, the fields caption name and other user specific helpful information on entering data into the field itself.

Would anyone know how I would go about :-

1) opening the subform (done this)
2) locating the specific record that matches the name of the fields control source on my main form

For example, simply, I have two fields on my form - fielda and fieldb. When I double click either of these fields, the same form opens but I get information displayed about fielda if I have double-clicked fielda and so on ...

Thanks in advance for any help.

 

[wiklendt]

i think you're either confusing what a record is, or you've not got a normalised database.

and could you clarify please, do you mean you want to return the DATA in a record, or things like settings, control name, field name.... (which begs the question: why?)

 

[mous]

Perhaps, I haven't explained myself very well then because I know what a record is as my database is normalised, thanks!

FieldA and FieldB could contain any sort of data is doesn't matter. What matters is the field name.

I have created a seperate table that contains:

Field Name : FieldA
Field Description: This is FieldA.
Field Database Title: Would you like to use FieldA?
Field Other Database Reference: RRFieldA
Field Further Notes: This is FieldA. It must match one held in the XX Guide and it must be completed where there is a value is Field XX.
Field Hyperlink: For Further information on using this field view http://mydocuments.com

It's a bit like a custom help file. The "help" form would open and show the detailed record for FieldA if the user double-clicks the FieldA field or the detailed record for FieldB if the user clicks FieldB.

Thanks again.

 

[wiklendt]

Perhaps, I haven't explained myself very well then because I know what a record is as my database is normalised, thanks!

FieldA and FieldB could contain any sort of data is doesn't matter. What matters is the field name.

I have created a seperate table that contains:

Field Name : FieldA
Field Description: This is FieldA.
Field Database Title: Would you like to use FieldA?
Field Other Database Reference: RRFieldA
Field Further Notes: This is FieldA. It must match one held in the XX Guide and it must be completed where there is a value is Field XX.
Field Hyperlink: For Further information on using this field view http://mydocuments.com

It's a bit like a custom help file. The "help" form would open and show the detailed record for FieldA if the user double-clicks the FieldA field or the detailed record for FieldB if the user clicks FieldB.

Thanks again.

oh! do you mean you want something similar to a tool-tip (or balloon tip, or whatever they're called?) you can do them easy for each control using the "controltip text" property...

as for the ones that you need more explanation (like the really long help info you have for the notes) you CAN actually make a 'real' help file of your own! that's where the HelpContextID property comes into it etc... i have no idea how to actually do this, but i know there is definitely a fair bit out there on doing it. start with "custom help file" in the search engine on the forums and see if that gets you what you want.