Lookup an auto populate

[Keiath]

Hi Guys

on a subform i want to lookup a value in another table (which I do using a combo box) then i want it to auto fill in the description in a txt box, and save that information in another table.

How to do?

 

[pr2-eugin]

Are you talking about, Displaying related info from another Table when a selection is made?

 

[Keiath]

Are you talking about, Displaying related info from another Table when a selection is made?

I use the combo to 'see' the exp code and the description, but only want it to display in the combo the exp number as i have to use that for another fuction, in a txt box next to it i need it to the auto populate the description of the exp code.

 

[pr2-eugin]

I don't get what that's actually saying I need to look up in a combo my exp code, in a txt box next to it i need it to the auto populate the description of the exp code

So what is the row source of the combo box? What is the code in the AfterUpdate event of the ComboBox?

The link I gave explains the steps in very simple words..

 

[Keiath]

I attach the database,

on the form Annual Accounts Form and the Income and Exp Tab

you can see i have a combo box to look up the code i want (which saves in the main table) in the txt box next to it i need to to display the description its the later part I am having issues with


Thanks for your help btw

 

[pr2-eugin]

You have not used the After Update method..

Private Sub Combo163_AfterUpdate()
    Me.Text169 = Me.Combo163.Column(1)
End Sub

 

[Keiath]

You have not used the After Update method..

Private Sub Combo163_AfterUpdate()
    Me.Text169 = Me.Combo163.Column(1)
End Sub

Great thank you

So going on form there, looking at the database again on the tabs you can see invoice, in another tab via a query i have summarized the totals by exp code

so if i select Group A code 55 in the value box after description (see new attached database) what is the code for this?

The only site number with any data is 0289S

Thanks again