Open subform based on a specific field on main form

[baktash]

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.

[rpeare]

I don't think you're using subform the way it was intended. subforms are displayed on the current form. The way you are describing it you are clicking a button (or some other method) to open a completely different form and show a subset of data (your document form). If this is the case you probably need to set the RECORD SOURCe of your documents form to a query (NOT your documents table by itself) and put a criteria in the TRANSMITTAL NUMBER field of forms!<primary form name>!TRANSMITTAL NUMBER.

This assumes of course the text box with your transmittal number on your primary form is actually called transmittal number, if not, just change it to whatever the name of the text box is.

[baktash]

thanks rpeare,

Well, I got it to work using a simple query with "[Forms]![f_transmittal]![Text27]" in the field criteria. But now, my "duplicate" command doesn't work properly in the subform.

do you have any suggestions on how to duplicate the selected row with its entire content onto a new row?