Hello all,
I am new here and I like some help with a filtering issue I am having with opening a subform based on a value in a specific field in the main form.
1. I have two forms (Transmittal form and Document form). The Document form is actually a subform to the Transmittal form. Both forms are linked based on a field called Transmittal Number.
2. There is a button on the Transmittal form that opens the Document subform. When the Document subform opens, I like it to be filtered based on the current Transmittal Number field.
Sounds simple but I can't seem to get it to work. I would appreciate a simple and easy way of doing this process. Thanks in advance everyone.