Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Working with Combo box and Text box

Author  Topic 

s3iLa
Starting Member

1 Post

Posted - 2009-09-13 : 03:14:45
Hi there!

I am fresh with Ms. Access and I really need help about it.
I couldn't make Combo box and text box work as my expect.
I have tblProductList so the table must like like following.

1-tblProductList
ProductID Product Code Description
1 FLA-LAC-4GB Jetflast Lacie 4GB
2 FLA-LAC-8GB Jetflast Lacie 8GB

When I work with Form Design (Not Wizard). I draw Combo Box for select Product Code, it works fine but it doesn't show Description feild in text box which i draw (without wizard). Any idea about it?

Thank you in advance for helpful.

Later

stephenbaer
Yak Posting Veteran

71 Posts

Posted - 2009-10-10 : 10:38:31
You're using the combo box to go to a record, not change data? Use the wizard! When you create a combo box in design view, it is usually for changing data, not moving to the record selected. If you use the wizard, it will build the code to move automatically. If you're not careful, playing with that combo box will change your data. It sounds like your form isn't bound, so you should be safe for now.

----------------
-Stephen
Go to Top of Page
   

- Advertisement -