I have a table, tblAIRCRAFT that has the following fields:

ID: Autonumber
AircraftType:
AircraftWeight:
WingSpan:
Design:

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?

Hi,

What is in the Column Count property for Combo34 control?

Just my 2 cents...

Just found that was the issue. Only had 3 columns counted...Thanks.

That's what I suspected. Glad to hear you got it figured out.

Good luck with your project.