Hmm, not the clearest subject line. Let's see if I can make it clearer. I have frmApplication, based on tblApplication. tblApplication contains fldConcat, fldLocation, fldMode and a few others. fldLocation and fldMode are looking up values from a "dictionary" table, so Location will always be the same. the values of fldLocation come from tblLocation. frmApplication displays those three fields. I want the values of fldLocation and fldMode to default to the appropriate values, based on fldConcat. fldConcat would have a typical value of "110100 0601 E 33" Using split() I am able to retrieve the information I want from Concat, so for example, I can get a string that tells me that location=33 How would I pass that information to fldLocation, considering that 33 is the value of colum(3)??? I've considered doing a dlookup, looking up the primary key of the record in tblLocation based on the string returned from the split(), but wouldn't there be an easier, more "elegant" way?