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
Expert: Scottgem Date: 7/18/2008 Subject: Problem in continuous Form
Question QUESTION: Sir I am using Access2000.
I want to know is there any procedure by which unbound text box can show different value corresponding to the value in another control of the CONTINUOUS FORM.
ANSWER: no. A continuous form is a single set of controls that are displayed multiple times. Therefore any change made to an unbound controls will be reflected in all displayed copies.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: MS Office Access 2007 VBA
---------- FOLLOW-UP ----------
QUESTION: CAN YOU GUIDE ME IS THERE ANY WAY i CAN PERFORM LIKE TASK WITHOUT USING UNBOUND CONTROLS.
I WILL TRY TO EXPLAIN YOU WHAT I WANT THEN PLEASE GUIDE ME HOW CAN I DO THIS.
========================
Please read what i am doing and what I want
I want to add two fields Account ID and Account Title in a continuous form.
I have Chart of Accounts table which has all info of Account ID, Its Title etc.
In Sales table I only store Account ID and respective sales Data.
In Sales Form I enter Account ID and it lookup automatically for Account Title from Chart of Accounts.
I have to scroll all the way to lookup required Account Title as I can only Enter Account ID (values of Account ID combo box are Sorted by Account Title).
To shorten this search time I wanted to type Account Title and it enters the value respective to that Account Title automatically inserts in Account ID field.
I found this way out by using an unbound combo box named "cboAccountTitle" putting query behind it.
and entering this code in "After Update"
Code:
Me.cboAccountID=Me.cboAccountTitle.column(1)
.......(Where First Column has Title and Second column has its ID)
This method worked fine until I used same method in continuous form.
That unbound cboAccountTitle show in all rows same value respective to current focused rows AccountID value.
I want to show different values in every ROW?
How can I perform this task? Through Query or Coding HOW?
ANSWER: You should have a combo bound to AccountID and an unbound textbox with a controlsource of:
=[cboAccount].Column(1)
In The account combo, ID should be the first column and title the second one.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
---------- FOLLOW-UP ----------
QUESTION: Thankyou very much for replying.
I think you have not read my follow up I am already using your method as you can see.
Please please read what my problem is and tell me if there is any solution
Answer Please reread my answer. You said you were using the After Update event to assign a value to the textbox. My last answers was to set the Controlsource of the textbox. That is a different method.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: MS Office Access 2007 VBA
