Edit DLookup Value?

[McArthurGDM]

I have a form that uses a DLookUp function as it's control source.



I can not edit the value that displays in the Text box. I suppose this makes sense, but how can I make it so that I CAN edit the value that displays from the DLookUp function?

Thanks,

[pbaldy]

If the value is coming from a combo box selection, this would be more efficient:

BaldyWeb - Autofill

If not, you can use the second method with your DLookkup(), in the appropriate event.

[McArthurGDM]

I'm not really sure why this worked, but

I ended up creating a text box whose control source was the DLookUp function. Then, in the After_Update function and using Me.Refresh, I set another text box equal to that value - so it generated that value. I can somehow edit that value and use VBA again to update the value should I make any changes.

If that made any sense.

[pbaldy]

Glad you got it sorted. That's basically what my second suggestion was.