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 SIr your Answer in my last question was
=====
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.
=======================================================
I used your answer and it is working fine but I am not able to select any value from combo box whose control source has
=[cboAccount].Column(1)
This is the reason I was using
=[cboAccount].Column(1)
in AfterUpdate property instead of in controlsource.
For your ref I am again posting my question. Please find a way out for me.
==============================
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 want to type Account Title in other control and it enters the value respective to that Account Title automatically in Account ID field of sales table.
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 works fine in all other forms where single form was used but not when 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 different Query or VBA Coding or HOW?
PLEASE FIND A WAY OUT FOR ME
Answer You seem to have a problem with reading my instructions. I didn't say to set the controlsource of the combo, but of the textbox!!
I just tested this and it will display the valie of the referenced column for the current record.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: MS Office Access 2007 VBA
