Hi everyone, is it possible to populate an unbound text box with data that is calculated in a query. I have 6 functions associated with 6 text boxes that I will hide in the form. Hopefully when one out of the four populates in will show the value in the visible text box. Any help will be apprciated.
Ok i got it to populate. That was easy. Didn't use my brain to much. The next problem I have is something like this. Only one of the 6 text boxes will ever be populated. How do I write a statement that says if [textboxname]=null then show [textboxname] and if that is null show something until you have a value?
can you restate that last sentence one more time? kinda confusing. i get from it that you look at the first textbox, and if the value in it is null, then you show it, or move to the next textbox and check it? thanks.