Recall 2nde column count with query

[TheunsGoosen]

TheunsGoosen (TechnicalUser) 17 Jan 07 7:41
Access beginner!
Good Day, can someone help!

In the 1st table I have the following two fields:
BussinessPartner and Bill-to City

In the 2de table the following to fields
BusinessPartner and City

If you select BusinessPartner in the second table a 2 column dropdown combo box appears displaying the two fields of the first table, on selection I would like the query to take only the second column, Bill-to City, to display it in the City field of the second table.

I don’t get the code right?
[BusinessPartner].column(2) ?

Thanks
Theuns

 

[traingamer]

Will you stop re-posting this question? See
thread181-1323258

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Remou]

Please listen to TrainGamer. LesPaul is very helpful and has asked two questions you have not answered. This is not polite.