Autopopulating problems.

[cms2012]

Hey everyone,

I have a form that when I select choices from a combobox it autopopulates textboxes with the information. All of that works great. What I am having a problem with is that I would like to put N/A in the text boxes when there is no information to put in the text box.

Here is a scenario: My data ranges from 2009-2012. I have text boxes that get filled with the data that is from the month of the year that is selected. So if say January 2009 is selected then these textboxes get filled with data. I also have text boxes that need to be filled with the data from the same month but in the previous year. The problem is that there is no data for 2008. How would I get N/A in the text box if that happens?

Thanks

 

[Catalina]

I guess that after the fields have been populated from the combo you can test the fields if they contain any info, and if not, put n/a in it.

Something like this:

If Len(Me.yourtextbox & "") = 0 Then
Me.yourtextbox = "N/A"
End If

Catalina

 

[cms2012]

Thanks that worked great!!

 

[Catalina]

You're welcome.