Form record source query where I need to show 2nd column

[Delta729]

I have a simple form made from the following record source with the following sql statement. My form is showing only the RegionID. What do I need to change that.

SELECT tblRegion.RegionID, tblRegion.Region, tblRegion.Vendor
FROM tblRegion;

I tried

[Region].[Column](2)

in the form field control source, which appear correct from what I'm finding online however it tell me that I have an invalid control source. Can anyone out there tell me I have wrong?

[Delta729]

I added this so I could pull in the 3rd column without seeing the vendors primary key. So that portion works for the 3rd column without having to do anything special with coding.

SELECT tblRegion.RegionID, tblRegion.Region, tblVendor.VendorFROM tblVendor INNER JOIN tblRegion ON tblVendor.VendorID = tblRegion.Vendor;

[Delta729]

I have no idea what happened, but I took a little break and now it works.