I have a table with following columns (+ example of data):
TankID TankName CoverID Marking WhereToFind
Frame
F042 FO Tank Hold 4 S 22 402-405 F042-SB-FO-22 Catwalk aft of hatch 4 SB
F042 FO Tank Hold 4 S 24 402-405 F042-SB-FO-24 Cargo hold 4 SB
On a form I have a combobox, with all TankID's shown. The idea is that when I select a specific TankID, then the data for that specific tank should be shown in some text boxes on that form. As each tank has between 1-10 covers, I have "10 rows" of text boxes, like this:
txtCoverID_1 txtMarking_1 txtWhereToFind_1
txtCoverID_2 txtMarking_2 txtWhereToFind_2
txtCoverID_3 txtMarking_3 txtWhereToFind_3
txtCoverID_4 txtMarking_4 txtWhereToFind_4
etc
I would very much appreciate if somebody can assist with the code needed for the combox 'afterupdate' event, in order to do what is descibed above.
Should additional information be needed, please let me know.
I'm unfortunately not able to attached any file, as I'm currently in an 'un-civilized' part of the world, with very limited access to the net.
Best regards
Anders
TankID TankName CoverID Marking WhereToFind
Frame
F042 FO Tank Hold 4 S 22 402-405 F042-SB-FO-22 Catwalk aft of hatch 4 SB
F042 FO Tank Hold 4 S 24 402-405 F042-SB-FO-24 Cargo hold 4 SB
On a form I have a combobox, with all TankID's shown. The idea is that when I select a specific TankID, then the data for that specific tank should be shown in some text boxes on that form. As each tank has between 1-10 covers, I have "10 rows" of text boxes, like this:
txtCoverID_1 txtMarking_1 txtWhereToFind_1
txtCoverID_2 txtMarking_2 txtWhereToFind_2
txtCoverID_3 txtMarking_3 txtWhereToFind_3
txtCoverID_4 txtMarking_4 txtWhereToFind_4
etc
I would very much appreciate if somebody can assist with the code needed for the combox 'afterupdate' event, in order to do what is descibed above.
Should additional information be needed, please let me know.
I'm unfortunately not able to attached any file, as I'm currently in an 'un-civilized' part of the world, with very limited access to the net.
Best regards
Anders