2 dependent combo boxes on a datasheet

[ice-9]

I have 2 combo boxes on a datasheet.
combo 2 is depedent on comboxbox 1.
But when i work on futhter and click other occurenses, the values change (because of the query looking at the first combobox)

this is very annoying.
can someone pleeeeease help,
ive been trying for 2 days now

thanks

Joost

 

[ailyn]

Have you tried queries?
Here i have a link that could be useful:
http://www.fontstuff.com/access/acctut10.htm

 

[ice-9]

Have you tried queries?
Here i have a link that could be useful:
http://www.fontstuff.com/access/acctut10.htm

I can get the lists corect, only the displays is wrong, because of the change of list.

Let me explain by picture:

The area is determining the information in de subjectcombobox
when i add a new record, and select a diffrent area, the subjectlistbox changes, but it changes over the whole sheet, not showinf the previous information. I still does exsist in the table, but because of the query list, it isnt selected.

Picture one you see the information
Picture two, you see i selected a diffrent area, and all the subjects disapear (but still exist)

 

[ailyn]

I'm sorry Ice-9, but I'm a newbie too. I would try to help you but without knowing your queries or anything it's quite difficult. Do those combos feed on other tables and are joined by Ids? Are there queries for them? Is this datasheet a table or a form in datasheet view?...

 

[ice-9]

I'm sorry Ice-9, but I'm a newbie too. I would try to help you but without knowing your queries or anything it's quite difficult. Do those combos feed on other tables and are joined by Ids? Are there queries for them? Is this datasheet a table or a form in datasheet view?...

i am affraid its a more expert question.
its a datasheet form, as the topic title reveals.

Im not realy sure if its the query that is te problem,

area:
SELECT Area.AreaCode, Area.AreaName, Area.AreaDiscription
FROM Area;

subjects:
SELECT Subjects.SubjectCode, Subjects.SubjectName, SubjectArea.AreaCode
FROM Subjects INNER JOIN SubjectArea ON Subjects.SubjectCode = SubjectArea.SubjectCode
WHERE (((SubjectArea.AreaCode)=[Forms]![MinutesInvoer]![AreaDummyy]));

areadummyy is a textbox where the areacode is temp. stored

 

[ice-9]

please help,

 

[ice-9]

kick kick kick

 

[ice-9]

why wont anyone help

 

[ice-9]

to difficult or not possible maybe ?

 

[neileg]

Sorry, ice-9, I'm struggling to understand your setup here. I think the problem may be that fact that you are in datasheet view. If you redesigned your form as a continuous form, I suspect this will sort the display out.

Can you post a stripped down version of your database so we can see what is happening?

 

[ice-9]

Sorry, ice-9, I'm struggling to understand your setup here. I think the problem may be that fact that you are in datasheet view. If you redesigned your form as a continuous form, I suspect this will sort the display out.

Can you post a stripped down version of your database so we can see what is happening?

whats happening is that i have cascading comboboxes on a datasheet.
The controlsource of combobox 2 changes when combobox 1 changes value.
This will result in a list change. But because you have a view of multiple records, the list changes for all the records, eliminating those values that are not in the list. These are still stored in de database, but not correctly displayed on the datasheet. (see pictures)

same problem here:
http://www.access-programmers.co.uk/forums/showthread.php?t=86167&highlight=cascading+datasheet

microsoft support:
SYMPTOMS
When you select a row in a combo box in a continuous form or a form that is open in Datasheet view, the text portion of the combo box in other records appears empty.

CAUSE
The behavior occurs under the following conditions: • The form is a continuous form, or it is open in Datasheet view so that you can view multiple records.
• The combo box's RowSource property is set to a parameterized query to limit the number of rows in the combo box based on criteria in another field in the form.
• The combo box criteria for the current record eliminate the rows that were selected in the other records.

 

[neileg]

Well there you go. Microsoft are saying that they know this happens and there's no fix and they are not particularly bothered.

 

[ice-9]

Well there you go. Microsoft are saying that they know this happens and there's no fix and they are not particularly bothered.

made a work around with popups..
damn im behid sceduel