I am new with MS Access and I have developed a small database which is working perfectly. But I have the following issue and I could not do it myself and I tried all the ways.
Please find attached a jpg file "tbl&frm" containing a sample table and form for MS Access 2007. In the table tblAC_Detail, AC_Reg is my primary key because it will never be repeated in my data base.
Now I would like to request your help on how to create a query for the following problem:
When users select AC_Reg on the form, frmFlight_Details, I want AC_Type field (a text box) to appear automatically. For example, if users select AC_Reg as A5-AAA, then AC_Type text box should appear automatically A320-231, if A5-ABA is selected then A319-133, and if A5-AJA then B777-200LR and so on.
Your assistance in this regard would be highly appreciated.
Please find attached a jpg file "tbl&frm" containing a sample table and form for MS Access 2007. In the table tblAC_Detail, AC_Reg is my primary key because it will never be repeated in my data base.
Now I would like to request your help on how to create a query for the following problem:
When users select AC_Reg on the form, frmFlight_Details, I want AC_Type field (a text box) to appear automatically. For example, if users select AC_Reg as A5-AAA, then AC_Type text box should appear automatically A320-231, if A5-ABA is selected then A319-133, and if A5-AJA then B777-200LR and so on.
Your assistance in this regard would be highly appreciated.
