I have a series of text boxes that look up specific information based on a users selection in two combo boxes.
When the form is opened for the first time all of the text boxes are showing #Error in them. Is there any way that i can get them to show as empty until the user makes a selection in the appropriate combo box?
Because im using a DLookup string (typed straight into the textbox in design mode), if i changed this to the after update event, i could basically get my combo boxes to put a "z" in for arguments sake, and it'll still overwrite it with the desired value?
I found a really basic way to do this late last night (just thought of it at that point). It was to make the text box fore colour white, and then use Me!textbox.Forecolor = 0 on the combo box AfterUpdate event.
But i feel that this is a crude way to do it, but it works. I'll more than likely just be switching over to the method that you've told me about.