Help on MS Access

[joys]

Can anybody give me assistance on Access 2002 /2003 ???

I got a project and need help. I know best help comes from pixies.

[jseal]

joys,

NP. What do you need?

[Cheyanne]

I can help too! :D

[joys]

Thanks jseal and Cheyanne ,

Not sure if i can descride my problem here. Afterall, this is a sexual place.

I appreciate your help offer and would be glad if u wrote to me at:

cozturk {AT} nova-trade.com

Please write to me so i can explain the question

Thanks in advance

[Sharni]

This General Chat area is for things non sexual too.....you can dicuss the problem here

[joys]

The question is:

The project is too complicated to explain here but briefing on the question is, I have to identify the SITC (Standard International Trade Classification) code for each product of customers. The SITC system is a 5 digit system where the 1st digits represents the main commodity, 2nd digit reperesents commodities under it. As an example, an SITC code starting with 0 would represent Food and Live Animals and 01 would be Meat And Meat Preparations and so on.

What I needed to do has, when the 1st category was selected by the 1st category combo, the 2nd category combo would only give the data from the selected category in the 1st combo. I've done that with each combo's requery and works fine.

Works fine when entering data but not as so when editing it.
We don't have anything wrong with the 1st combo as it's "limittolist" propery is set to yes (like all others", but when editing, when I change the value of the 1st combo, the 2nd remains same even though the combo box is populated with the 1st combo's values. What I want to do is, if user leaves the 2nd combo same even though the 1st combo is changed, i need the program to interfere.

I've seen many questions and how-to's regarding adding an item to the combo but in my case i just want to restrict and have the user select what is defined.

[joys]

Thank u Sharni

[jseal]

joys,

I assume that the second combo box is populated by a query which has a WHERE clause sensitive to the bound value of the first combo box.

If this is true, then select [Event Procedure] on the After Update event on the first combo box’s property sheet. Add a requery on the second combo box between the generated Sub…End Sub statements. It should look something like this:


Private Sub <first combo box name>_AfterUpdate()
....Me.<second combo box name>.Requery
End Sub


The Update event should fire when you change the value of the first combo box, repopulating the second combo box with the values dependent upon the new bound value of the first combo box.

[Cheyanne]

Doesn't it depend if the combo box has been secured? If you have multi users and don't want data altered during general queries, you have to make sure that it is unlocked before you alter the data...

[joys]

Cheyanne: Lets not mention multi users for know.
jseal: your assumption is correct. ReQuery is already done for the 2nd combo and works fine. That is what I meant by "adding records". this is fine.

But if you come back to edit the record, say the first cat /cat(1)), the other cats cab remain.

example:
you enyered
cat1 00
cat2 01 ' this is ok
cat3 211 ' this cannot be in the query for cat 2

Wife just got this messed up, sorry, but hope it is understood.