Hi All,
I'm creating an airport database. And I'm having problems linking my form with my table.
I've created a tables with the following fields :
ICAO, IATA, Airport Country, Airport City, Elevation, Airport Usage : Inactive, Airport Usage : Destination Airport.
ICAO, IATA, ICAO, IATA, Airport Country, Airport City are short text.
Elevation is a number.
Airport Usage : Inactive, Airport Usage : Destination Airport are checkboxs.
I've created a form where :
- ICAO, IATA, Airport City are comboboxs that autopoputale each other and the Airport Country (which is not a combobox). Airport Usage : Inactive and - - Airport Usage : Inactive, Airport Usage : Destination Airport are checkboxs that if one is ticked the other one gets unticked.
What I would like to do, is when ICAO, IATA or the airport city is selected, it autopopulate the Elevation and the checkboxs with the information of the table.
I can't seem to link the ICAO, IATA, airport city with the Elevation field and the checkboxs...
I've tried a few things but none work.
I hope I am clear enough. If you want to to attach my database, please let me know.
Thank you for your help.
Mat
I'm creating an airport database. And I'm having problems linking my form with my table.
I've created a tables with the following fields :
ICAO, IATA, Airport Country, Airport City, Elevation, Airport Usage : Inactive, Airport Usage : Destination Airport.
ICAO, IATA, ICAO, IATA, Airport Country, Airport City are short text.
Elevation is a number.
Airport Usage : Inactive, Airport Usage : Destination Airport are checkboxs.
I've created a form where :
- ICAO, IATA, Airport City are comboboxs that autopoputale each other and the Airport Country (which is not a combobox). Airport Usage : Inactive and - - Airport Usage : Inactive, Airport Usage : Destination Airport are checkboxs that if one is ticked the other one gets unticked.
What I would like to do, is when ICAO, IATA or the airport city is selected, it autopopulate the Elevation and the checkboxs with the information of the table.
I can't seem to link the ICAO, IATA, airport city with the Elevation field and the checkboxs...
I've tried a few things but none work.
I hope I am clear enough. If you want to to attach my database, please let me know.
Thank you for your help.
Mat