AllExperts > Using MS Access 
Search      
Using MS Access
Volunteer
Answers to thousands of questions
 Home · More Using MS Access Questions · Answer Library  · Encyclopedia ·
More Using MS Access Answers
Question Library

Ask a question about Using MS Access
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Scottgem
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

 
   

You are here:  Experts > Computing/Technology > Business Software > Using MS Access > Change text box values as tab through datasheet.txt

Using MS Access - Change text box values as tab through datasheet.txt


Expert: Scottgem - 2/8/2005

Question
I've got a form with a subform and three text boxes on it.

The subform is a datasheet view of the query that is the form and the subform's record source. This subform works perfectly. My problem is with the three text boxes.

What I want to happen is this: as I tab forward and backward through the cells of the datasheet, I want the values of the text boxes to change according to which cell I'm in.

How?

The fields of the datasheet view are as follows:
  Category
  English
  Spanish
  Portuguese
  Kreyol
  French

It's simply a five language dictionary. The category field is for stuff like parts of speech, months, etc.

The three text boxes are as follows:
  Synomyms
  Antonyms
  Example

Here's the idea again. As I tab through the dictionary, I want the values of the text boxes to change according to the word (cell) that has focus, that is, I want the "Synonyms" text box to display synonyms of the word I select in the dictionary. Ditto for the "Antonyms" text box and also for the "Example" text box.

I've got the little database zipped up and ready to send. It has only two records in it so far.

Thanks!
-Dave

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.

HTH
Scott<>

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.