I have a form where I am creating a new client record.
After entering some of the new client information (Last Name, First Name, Date of Birth, Gender) I need to run a process that will display a query of potential conflicts with the last name just entered.
Right now I have a button on the New Client Form called 'Check for Conflicts' that executes the process that calls my potential conflict query.
The process does this:
Code: Select all
SessionVariables.Search_FirstName=TRIM(ClientMaster.FirstName)
SessionVariables.Search_LastName=TRIM(ClientMaster.LastName)
DISPLAY 'Check for Potential Conflict'
1. When I click on that button I get a message saying "There are unsaved changes in the form of object ClientMaster.
Do you want to save them?" I say 'No', the query runs,
2. But there is nothing in the SessionVariables, so nothing shows up on the query.
3. When I close the query (it opens in a popup) and return to the New Client Screen most of the previously entered information is gone. The only attribute that has anything in it is FirstName.
What I would like to have happen is...
1. After entering the date of birth I would like it to automatically run the 'CheckForConflicts' process. If I still need to call the process through a button, I can live with that.
2. I don't want the 'unsaved changes' screen to popup.
3. When I return to the New Client Form, after looking at the Potential Conflict Query, I would like the data I had previously entered to still be there.
Is any of this possible?
Thanks,
Jim