I have a table, tblAIRCRAFT that has the following fields:
I have a form, frmAIRCRAFTLIST the has the items from the table as controls:
Here's what I am trying to do:
When the aircraft type is selected the controls AircraftWeight, Wingspan and Design will be populated automatically. In the AircraftType control(Combo34) Row Source I have:
SELECT tblAIRCRAFT.ID, tblAIRCRAFT.AircraftType, tblAIRCRAFT.AIRCRAFTWEIGHT, tblAIRCRAFT.WingSpan, tblAIRCRAFT.Design FROM tblAIRCRAFT;,
For the controls AircraftWeight, Wingspan and Design I have: Weight (=Combo34.Column(2)), Wingspan = Combo34.Column(3), Design = Combo34.Column(4).
When I select an aircraft type the Weight and Wing Span will populate but nothing is populated for Design.
Any ideas on why this occurring?