June7,
Thanks for the info. I'll have to look into these options. For now I have modified the newly written code back to the full call out method....
I was implementing some new form code to simplify the long code strings....
Code:
With Me
.Parent = Dlookup()
End With
Since .Parent is reserved I changed the txtbox to .txtParent but then I couldn't find the query that referenced [Forms]![MyForm]![Parent].....
ended up changing that one back for now....
As always thanks for taking the time to respond. It means alot to have such a great resource at the tip of my fingers.