Hello All,
- In a form "frm20SelectArea" there is a listbox "lstArea" with two values (Area A & Area B)
- There is also a textbox "txtSup" in the same form
- Finally I have a table "tblArea" with three columns (AreaID, Area & Supervisor)
- How can the textbox display the supervisor looked up in the table according to the area selected in the list box?
i'd appreciate your help a lot!