I have a database which stores data about formula 1 races. The main data entry form contains, among others, a combobox which displays a list of Grand Prix circuits and a textbox (tboCountry) in which I wish to display the country associated with the circuit. I have constructed a query (qryCountry) which correctly shows a country based on the circuit selected from the combobox (cboCircuit).
I have placed this code in the on click event procedure of cboCountry:
Forms!Results!tboCountry = qryCountry.Country
This throws up an error – Object required.
I’d be grateful for someone’s help with the syntax.
Cheers
Rob