Awesome! Glad to hear you were able to make something that important using my videos. You made my day. :)
Austin Ritner
@Reply 6 years ago
You've been a great asset to the creation of it. With that being said, there's one thing that I wouldn't even know where to start on.
If there's an address entered into the "Dispatch A Call" form, for example 123 Easy St., I would like to be able to have a button that will search for any previous calls at that address.
Well, if it's simply a matter of matching the address, then you could create a query that uses the address field on the current form as the criteria. For example:
=Forms!CustomerF!Address
And of course city, state, ZIP would follow suit. The problem is if the address is typed in slightly different. "St." instead of "Street" for example. That's where cleaning your data comes into play - forcing standards. In a case like yours, you may even want to break up the address field into multiple parts:
StreetNumber: "101" StreetAddress: "Main" StreetType: "Street" "Avenue" etc.
Working with addresses does get tricky.
Austin Ritner
@Reply 6 years ago
Ah HAH!!! I ran the query and it works beautifully! Would I be able to make a form and use the query results from that as a pop-up?
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Testimonials.