DLookup

[mugman17]

I have a text box that uses a Dlookup function, I need to be able to have the option of manually entering something in this box as well. But of course, I get the control can not be edited error. I tried to put the function as a default value, but got nothing. It must be something simple I am overlooking.

 

[TGHockett]

I am not sure how you can accomplish what you are trying to do via Dlookup(), but I have accomplished the same thing by creating a combo box that pulls data from a single or multi-column query. By clicking on the combo box, the user has the option of scrolling to the item they want to select, or typing in the desired value.

HTH...

TGH