fill a value in a textbox when an item from a combobox is selected

[CaptainAargh]

Hello,

I have a problem and I don't know how to solve it.

I have a table, Registration, with 8 fields: inschrijvingsid,name,gemeente,gsm,telefoon,email,aankomst,gerecht,personen

I have another table, Login with 3 fields : Naamid,name,,status

Then I have a combox that is connected with fldname from the table Login.

In that form I have 8 textboxes:
name,
gemeente,
gsm,
telefoon,
email,
aankomst,
gerecht,
personen
And status.

Now what I can't. I want when I select a record from tblLogin Like for example Daan that I see in the textboxes his info from the tableRegistration.

Also when I change the textbox Status it and click "Verander status" it changes in the database.

How can I do this?
Please guys help me
I would be very appreciated!!

Thanks,

Nathan

PS: It's in dutch the acces file

 

[pbaldy]

Can't look at the sample right now, but does this help?

http://www.baldyweb.com/Autofill.htm

 

[CaptainAargh]

Solved it thanks to you!

 

[pbaldy]

Happy to help!