I have a data entry form where the contact database can be searched by Contact, Phone or Email. I found the ValueFromPopUp "widget" from this Forum.
That works great for a form with a single aspect (ie, Contact or Phone or Email). I want to have all three and the user select the lookup which helps the most.
If they find a match, then by clicking OK, the data entry form is populated. Otherwise, they click an Add Contact button to put in a brand new Contact.
So, there are 3 options to make this work.
From best to worse
1. Select Radio Button and one unbound field is set for one of the search criteria
2. Select Radio Button, and one of the three unbound fields activates
3. Three different forms
Any ideas how to make this work??
Thank you.
That works great for a form with a single aspect (ie, Contact or Phone or Email). I want to have all three and the user select the lookup which helps the most.
If they find a match, then by clicking OK, the data entry form is populated. Otherwise, they click an Add Contact button to put in a brand new Contact.
So, there are 3 options to make this work.
From best to worse
1. Select Radio Button and one unbound field is set for one of the search criteria
2. Select Radio Button, and one of the three unbound fields activates
3. Three different forms
Any ideas how to make this work??
Thank you.