Using form to pull information from multiple tables. Issue

[msherr1]

Hello, I have a database I've been scrapping together to help make budgeting a little easier. I use to do database stuff quite often, but stopped when I decided to pursue another degree and now am a bit rusty with this stuff. I have most of it working and it is pretty nice, however I am running into a final issue before I can really test it. In one of my boxes, I have a drop down list that pulls from, lets say, 'table1' and a text box below that assigns itself a value based on the value of the dropdown box (=[combobox1].column(1) for example). It appears the other combobox drop down is working (similar setup but pulls information from another table), but when I use the one from "table1" it gives me an error when I tab through "You must enter a value in the 'column(1)name.table1' field." Since the box is auto populated to pull that data from 'table1' why is it telling me to enter data when there is data already there? If needed, I will try to attach the database or screenshots.

[rpeare]

you can't use columns designations as query criteria
if you can't use the bound column of your combo box as the criteria for the last combo box then I would have a hidden field on your form with the control source =COMBOBOXNAME.column(x). Where comboboxname is the actual name of your combo box and x is the column you're after. Then in your query reference the field with this formula in it.