AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question -------------------------
Followup To
Answer -
If I follow you, the subform contains records where a word is shown in 5 languages. As you tab between each language column you want the 3 text boxes on the main form to display the appropriate value for the selected word and language. Have I got it?
Frankly I wouldn't do it that way. Firstly, there is often more than one synonym and/or antonym for a word, especially in english. I would be more inclined to put the words in the main form, then have three subforms, that show a list of synonyms, antonyms and an example.
But, what you want to do is use the GOT FOCUS event of the controls on the subform to set the values of the controls on the main form.
---------------------
Scott,
You've got the idea... almost. The "Antonym" and "Synonym" text boxes will display more than just one word at a time, and the "Example" text box will display a sentence in the given language, followed by its translation in English enclosed in parenthesis.
The fields of the tables where the antonyms, synonyms, and examples reside are data type "memo." That way I can populate them without worrying about running out of room.
Please give me an example of the "GotFocus" event. I really wish you'd let me send the database to you.
Thanks-
Answer I really don't need to see the database as long as I understand the concept. I would still do it as I said.
Without knowing the structure of your database I can't be specific with the GotFocus, but it would look something like thsi:
