Using formula language, is there a way to open a form and have it check a field(s) on another form and update the open form accordingly?
Thanks, Paul
Subject: Yes, it can be done
Hi, Paul. Your post is a little unclear as to whether a user is opening a document or you want code to do the open. If a user is opening a document and you want a field updated, you can put code in the Postopen event of the form( that the document is created with) so that the first check is to see if the document is in edit mode and then put it in edit mode. Then your code can do an @DbLookup to get the information from the other document. Finally, use a conditional statement to see if you need to use a field assignment statement to set the value of the field. If you want to update fields on documents without a user opening the document, then you can run an agent that uses a conditional statement to see if a field needs to be changed based on an @DbLookup to another document. The agent doesn’t really need to open the document if it is just a matter of updating a field. The document or documents just need to be the combination target of the agent and document selection of the agent for them to be acted upon.