MS Access 2007 Query Help

[tjames]

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.

[weekend00]

let's assume the name of the textbox for AC_reg is "AC_reg", and the name of the textbox for AC_type is "AC_type",
in form design view,
right click on the textbox "AC_reg", select "Build Event...",VB editor will open;
type in following code:

    AC_type=nz(dlookup("AC_type","tblAC_Detail","AC_reg='" & AC_reg & "'"),"")

[tjames]

Hi weekend00, thank you for providing me a simple solution. It worked though I have to either refresh or close the form to appear the AC_Type. But anyway, you solved my purpose and thank you once again.