Originally Posted by MajP
If I understand this correctly, then simply do this in the forms on current event instead of the controls recordsource. Bind the control to the correct recordsource. In the forms on current event something like
if isnull(me.someTextbox) then
me.someTextbox = yourDlookupFormula
This is essentially what I did.
In the "On Change" Event Procedure for the preceeding combo box, I put in a dlookup function that looked like this:
Private Sub Combo1_Change()
Text1 = Dlookup("[Field]", "Query")
So this controls the input into the textbox, while I can still have the control source to the field the form is tied to.
Essentially a text box with a control source, that acts like a combo/list box with a row source.