Recent content by homeshark

Well the data itself is categorized per say. Like 5 entries that fit the "Holly Kosove" go under the category "Holly Kosove" but instead of displaying the category name "Holly Kosove" it says #Num! So it looks like (example) Name: #Num! 80000 Data Data Data 81254 Data Data Data 84000 Data Data...

I am getting this #Num! error for a field which displays items like "Holly Kosove" and "Magnolia Complex". For all other items such as "Argos Complex" and "Andros Complex" it displays the name fine. Here is the code in its entirety: =IIf(IsNumeric(Left([Mail code or student box...

I am wondering how you would go about setting this up in a form. FYI this is on a switchboard gui. In Field A, someone can type in a specific number. I would like Field B to autopopulate with information based on what is in Field A. Field B’s information will come from a range. This is an...