[RESOLVED] Access Combo box to auto fill

I am having problems with my combo boxes

I have 1 combo pulling from my table fine but I want when it pulls the data for textbox2 to pull corisponding information from same table.

I am lost on this any help would be appriciated.

Do you mean like you have a combo being populated with a query result. Then when the user select a combo item you want to populate the textbox with some related data to the cbo selection? If so then you need to execute a secondary query with the combo selection as the criteria of the call. Like "SELECT SomeField WHERE SomeField = '" & combo1.text & "'"

I am still having problems with that part. I dont think I am grasping the how it is working so I cant do what I need to do. I am going to post my file. Can you please take a look at it and see if you can explain to me what I need to do?

I made a few changes and its working.

Thank you once again RobDogg!!!!


:thumb: :afrog: :wave:

Glad to help. :) I didnt have the Cabin Names linked table so I just took it out. I just wanted to show how to retireve the data and enter it. You can change to your needs.

I do not know if it is that my system is not wanting to open the file but I have coppied the code and the tables and I can pull the information up but when I pull up a product it is not filling in the cost of the product in the cost column. Any Ideas?

Look at the Cost columns RowSource property.

Code:

---

SELECT Products.Cost FROM Products;

---

Still did not change. I can select the information from the drop combo box but it still will not automaticly fill in the box when I select something. The information is being pulled from the table and I can select the correct price under the cost but it is not automaticly filling it in.

What do you mean "filling it in". Just like my example db or something different?

I can not get your DB to run. It gives me a read only pop up and will not let me try it out and see if it is what I need. I am trying to get it to pull Product 1 and that is linked to cost of product 1 and I want it to automaticly print in textbox when product 1 is selected.


However I think I have just done what I am looking to do by using the Report function and sub forms. I need to do a couple of more test then I will post my crazy DB on the page.

Ok, but make sure my db is not marked as Read Only on your filesystem. It is an 2002-2003 file format so it should be ok.

Here is my DB file. It is not how I was trying to get you to help me do it but it works. Let me know what you think!