InfoPath Dev

This data may change often yes. Also, I noticed that the drop down box works now, but I still get the same error if I follow my original methodology for the submit button.

Thank you! You helped me solve it. I went to the "Data" tab, then "From Other Sources", then "From database". The data connection wizard then opened. I then followed the steps outlined in my attached screenshot. I told it to store a copy of the data in the form template because my database table is small enough. I ...

Thanks again! As you guessed, no values are being returned. I added a dropdown box and it returns nothing. I checked the Access database to verify there are indeed values in this field, and there are. I've also attached a screenshot of what my drop down box properties were if that helps. The field is formatted as a Text field in the Access ...

Anybody have some ideas?

Hi Hilary! Yes this form is based on a database. Why would the query try to return more than one value? If you look at the screenshot in the first post, I have tried to filter the data to only return @EMAIL when @DESIGNATION = 'RANK1'. Is this incorrect? I have attached another screenshot of how I am filtering the data. Thank you ...

Good morning all! I am trying to get a submit button to email to a certain person in a database that has a certain position title. I've attached a screenshot of the button properties. The thinking is that I could just manage the database to have the form change when new people come into certain positions. We have many different forms ...