populating bounded textbox

[snoopy22]

Hi,

I've posted this problem before but now i've simplified it...

my project include 2 tables:

1.Emplyees
it fields are:
1.1 EmpID
1.2 EmpName

2.Transaction
it fields are:
2.1 TransactionID
2.2 EmpID
2.3 EmpName
2.4 Debit
2.5 Credit
2.6 Balance

I've created a form based on Transaction from the wizard with two buttons: new & save
on this form: I want to populate the EmpName textbox by the selection of the EmpID.
for example, if i type "2" on EmpID then the name of Employee no. 2 will appear on the
EmpName textbox.
I've managed to do it before, but my problem was that when i've pressed the "save" button
all data saved correctly on "Transaction" table, except from the EmpName field.
basically my thought was: making the EmpName textbox into Listbox, In it rowsource
add the Quary, and on event afterUpdate(of the EmpID textbox) to requary the EmpName
textbox. like i've said before, it did display the correct name but didn't save it.

I've Deleted all my code,and added the project ()

please tell me what to do!
p.s. sorry for the long post.

 

[snoopy22]

thanks man

I've got it working