i need help with simple query

[TheunsGoosen]

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 select ion I would like the query to take only the second field, Bill-to City, to display it in the City field of the second table.

I don’t get the code right?

Thanks
Theuns

 

[traingamer]

Double-posted - see thread181-1323258

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

 

[TheunsGoosen]

Sorry i'm new with posting threads on forums, if i still don't understand how to resolve the problem with the response, how do i go about trying without reposting?

Regards
Theuns