Hi Everyone,
I have an application that has a stateless form called frmAgency (see below):
This form corresponds to an identical regular form that is hidden from the user's view. The user would click the search button on the left and it would use the openurl command to open the frmAgencySearch (see below):
With this form, the user would either enter an Agency ID number or type a string of characters in the strAgencyName field. This would cause the multi-select box to be populated with agencies that contain the text string. The field strParentForm is populated by passing a value into the field that corresponds to the form that opened it and would be hidden from the user's view.
When the user highlights one of the agencies and then clicks the select button, it should then close the popup form, re-open the original form and populate the fields with the data from the tblAgency table.
Everything seems to be working fine except for populating frmAgency. I can't figure out how to do it. I've just recently figured out how to use maps and I'm sure maps would be involved, but I can't figure out how to do it. Would it also involve the postURL statement? I could really use some guidance.
Thanks,
Leo Saumure