How to get Combo Box to display two Fields on Form

[bethabernathy]

Hi -

I have a form where I want to display the combo box "ZipcodeID" and related text field "Area". I can add the combo box named "ZipcodeID" onto the form but can't link in another field from that table.

There must be a method to handle this, does anyone have any suggestions.

Thanks, Beth

beth@integratedresourcemgmt.com

 

[bethabernathy]

I figured it out. Add an unbound text box to the form and use the dlookup syntax - i.e.:

=DLookUp("[Area]","tblzipcode","[ZipcodeID]=" & [ZipcodeID])

Pretty cool!!

Beth beth@integratedresourcemgmt.com