Subform filter issue

[fredalina]

Hi, guys, i have a little problem. i have a form (called RDR Search) which is used to search for a specific record in a table by one of three fields: SupplierCode, PLNumber, or Date. There is also a subform listing these three fields below, filtered from a main table. The field opens to these three options as option buttons. (This works currently).

Depending on which is selected, a combo box becomes visible with the appropriate fields allowing the user to select from the boxes. The combo boxes are cboSupplierCode, cboPL, and cboDate. (This works currently).

i want a subform to then show all records pertaining to that SupplierCode, PLNumber, or Date, but this is where i am stuck. Then, i would like the user to be able to click or double-click the applicable record and have a different form, called RDR, open, filtered to that record.

Can you help me to set this up, or to suggest an alternate method that will accomplish these results? Ultimately the user needs to be able to search for any of the 3 fields, and needs to be able to select the search criteria from combo boxes, and ultimately have the separate main form open.

Thanks!

 

[georgedwilkinson]

Sounds like you've got it upside down. You normally navigate to subform records from the main form.

See if this link helps:
http://allenbrowne.com/ser-28.html

 

[fredalina]

Thank you. Unfortunately the link was not particularly helpful to me.

i am indeed trying to display subform records based on combo boxes in the main form.

From there, i would like the user to be able to select the specific record and have it open yet a different form (which happens to be the main data entry form for the data called RDR) filtered to that particular record.

In this case, from the startup form, the user clicks a button to either start a new RDR, or search for an existing RDR. By selecting "Search for an Existing RDR", this form RDR Search is opened, which contains the subform. Does that make sense?

Once the selection criteria have been waded through, i would like the user to be able to select a particular record and have the RDR form open to that specific record.