Solved

Combo box depend of an other one - update problem - Access

Posted on 2008-10-29
3
538 Views
Last Modified: 2013-11-27
Hi,
I have a continuous form that shows multiple records.
On that form, for each record, I have 2 combo box (cmbDirection, cmbTitle) where one depends of the other, base on a query.
When I select a value on "cmbDirection",  the values in  "cmbTitle" combo box changes.

My problem is, when I change the "cmbDirection field" for one record, all "cmbTitle" values for all other records are change at the same time and take the values associate to the "cmbDirection» I just selected. That means, other records don't have anymore the right "cmbTitle" values.
How can I correct this?
Thanks,

Carol

cmbDirection combobox: (2 Columns, 1 description,  the other the Id)
Event:
  Private Sub cmbDirection_Change()
       Me.txtDirectionID = Me.txtDirection.Column(1)
      Me.cmbTitle.Requery
  end sub


cmbTitle combo box RowSource property :
  SELECT qry_Title.formationTitle FROM qry_Title;

Query qry_Title :
  SELECT tbl_Description.Title AS formationTitle,    
                  tbl_Description.IdDirection
  FROM tbl_Description
  WHERE  
(((tbl_Description.IdDirection)=[Forms]![frm_Formation]![txtDirectionId]));
0
Comment
Question by:Karl001
  • 2
3 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 22832008
This is a characteristic of continuous forms.
At any point there can only be one rowsource for a control - no matter how many copies of that control you can see.
Therefore when the value in one record is not contained in the rowsource, because the rowsource is now based on some other records data, no value shows in the form for that record.  This does not effect the value stored for each record.

To show the current record value for every record, you have to use a checkbox.  By careful placement of the checkbox and the combobox, laying one on the other, and use of transparency settings, you can create the illusion of a drop down list which displays the correct value for each record.
0
 

Author Comment

by:Karl001
ID: 22832550
I don't understand the simulation of a drop down list by using a checkbox.

thanks

Carol
0
 
LVL 77

Accepted Solution

by:
peter57r earned 250 total points
ID: 22832945
Sorry my typo.

Textbox.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now