[RESOLVED] Access Combo box to auto fill

[jmhfloor]

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.

[RobDog888]

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 & "'"

[jmhfloor]

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?

[RobDog888]

I made a few changes and its working.

[jmhfloor]

Thank you once again RobDogg!!!!

[RobDog888]

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.

[jmhfloor]

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?

[RobDog888]

Look at the Cost columns RowSource property.

SELECT Products.Cost FROM Products;

[jmhfloor]

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.

[RobDog888]

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

[jmhfloor]

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.

[RobDog888]

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.

[jmhfloor]

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!