auto populate combo field?

[myboii]

dear all,

good day!

would like just to seek for an assistance.
my problem is how can i automatically populate the
data into the combo txtbox2 after i updated or input the data
in combo txtbox1.



wish i could have the answer soon. this will help me more in my project.

thanks in advance.

regards,
bryan

[Rawb]

Just create an After Update Event for txtbox1 that sets the value of txtbox2.

Me!txtbox2="Blah!"

[maximus]

here are some questions that I would like ask here:

1) Update what do you specifically mean by that.
2) If it is that the data which is entered in a text box will appear in a combobox then I have the following question:
a) What is the Row Source type of your combo box. A value List or a SQL or a Table.

[myboii]

thanks rawb and maximus.

anyway i still couldnt get this out,

what i mean for this is when i selected the code data to my combobox1
like 0001, combobox2 will automatically populate the corresponding data like
e.g. sample001. i have created a tbl name supplier details and the code was
there, supplier name and the address. so whenever i choose the code in combobox1 the assign name and address shall be populated in the combobox2 and 3. so i could minimize typing all the names and addresses.

thanks and regards,
myboii

[maximus]

This is a link to a thread that i think will help you. I had attached a small sample mdb file in this post. Download that. It is a pretty simple set up study the relationships. if you have any problem let me know.

https://www.accessforums.net/forms/l...help-6321.html

[myboii]

hi maximus,

cant find the code. pls help me on this is my access db and form that should be working.

for your usual assistance pls.

thank,

[maximus]

I have done the need ful when you select a supplier code name and address is automatically updated.

refer attached sample.

[maximus]

mark the thread solved

[maximus]

is your problem solved