Setting a Text Box's Default Value as a Query Result

[iamedwardkim]

I am able to set a combo box's row source as the return values from a query. However, I am trying to set the default value of a text box as the result of a query, where I know only one value will be returned, and I am unable to do so. Can someone please help? Thank you.

 

[RichD]

I would place the following code in your form's On_Current event, that way it will enter the default value each time it finds a null text box.


if isnull(MyTextBox) then 'assign default
MyTextbox = dlookup("DefaultValue", "Myquery&quot
end if

HTH

Rich



Lead Developer

http://www.blsoftware.co.uk