Save Problem

[snoopy22]

Hello guys,

I've got a form bounded to a table("transaction"), when the user enter number in
txtPreyerBillNo, the Preyer's name appear automatically in the lstName
I've done it by putting a quary into the row source of the lstname:
SELECT Preyers.Name, Preyers.PreyerBillNo FROM Preyers, Preyers AS Preyers_1 WHERE (((Preyers.PreyerBillNo)=Transaction.PreyerBillNo));

and on event afterupdate of the txtPreyerBillNo I've added this code:

Private Sub txtPreyerBillNo_AfterUpdate()
Me!lstName.Requery
End Sub

the name appears, and it works just fine...
My problem is:
when i press the Save record button (created by the wizard), it doesn't save
the lstName (on the table it appears blank) into the table. and yes... lstName is bounded to the right field.

 

[sonny]

Can you post a sample db for this problem. I saw your post from the other site...

 

[Mile-O]

If you are getting it to display on a form then it's fine - you don't need to store such values.

 

[snoopy22]

but I want to save it!

here is the sample, the language of the project is not
english so I hope you'll get it right.

 

[snoopy22]

shit,

the file is too big even in winzip...

 

[Mile-O]

You say you can get the value but you want to save it.

Either something is incorrect with your database design or you don't understand database design.