Get value for text box depending on other text box !!

[arifmasum]

Thanks for reading my post. My problem goes as folloing:

I have several sub_code under Account_code.
In my subform i have two combo boxes. 1 is account head another is sub head. There are several sub heads under 1 account head. I need to get those sub head depending on the account head.
My problem is I get the sub head values for the 1st account head only. I need to enter multiple account head and sub head in my sub form.
I am stuck here. can anybody help me out?
Thanks in advance.

Arif Masum

 

[RuralGuy]

Arif,
I'm not clear what you are trying to accomplish. Can you supply a picture or maybe a sample db so we can get a better understanding what you have and what you need?

 

[arifmasum]

Here is the picture

Arif,
I'm not clear what you are trying to accomplish. Can you supply a picture or maybe a sample db so we can get a better understanding what you have and what you need?

Here is the picture. See the textbox below VDate contains value 27 is the Account Head code (it is hidden). There are several sub codes under this code.
I am using this text box in query to get the value for the sub code in the sub form.
I am able to get the sub code value using query.
My problem is when I try to get the sub code for the second account head (Rent), It returns sub code for the advance deposit and pre payment (27) only.

Hope you understood my problem. I am stuck here. Thanks in advance for your time and reply.

Arif Masum

 

[RuralGuy]

Sorry but you lost me. How do you put the 27 in that text box?

 

[arifmasum]

This is the code

Private Sub Account_Head_Click()
[Forms]![CreditEntry]![Text20] = [Forms]![CreditEntry]![CTrans]![Account Head]
End Sub

I used this code to pass Account head code to the mainform. I used this code on the code section of the subform.

Thanks n best regards

Arif Masum

 

[RuralGuy]

See if this link helps some in your syntax. I'm also going to guess that you are using Lookup Fields in your tables.