Good morning, Nils.

Good catch! Richard defines a variable "OrderBy", but he does not use it.

For your second point, just make sure that "Requiryform" is either in the open, load or oncurrent event.

Yep. Good catch.

Thanks Gentlemen,
I am looking for a video or course that discusses searching or filtering a main form by a selection of a record in a continuous subform. (filtering the Parent records by selecting a Child record).  Example:  Main form is based on a table of Parents (Mr. & Mrs Smith, Mr. & Mrs Jones, etc).  The subform is based on a table of their children (Richard, Sue, John, Mary, etc.). A one-to-many setup.  I want to be able to select "Richard" from a search or filter box, and have the main form be filtered showing all parents who have a child named "Richard".  In my case the main form is a table of complete outfit names (for my wife's Fashion line), the subform is a list of styles in that outfit (Bomber Jacket, Silky Tee, Sublime Pants, etc.).  I want to filter the main form to show me all outfits that contain the "Bomber Jacket" for example.  Can you steer me towards the Tech Help or Course please?  Thanks,
Nils

You can easily do that with an event on, for example, double-click on the child's name "Richard". That will trigger a command to open the appropriate parent form with a parent record displayed. This assumes that you have the parent ID stored on the child's table. The command will look something like this:

Docmd.openForm "ParentF",,,"ParentID= " & ParentID

Thanks Sami, but I want ALL of the parent records who have "Richard" as children to get returned.  Then I can browse through those with record selectors.  I think it has to be a query somehow maybe.  I'll keep at it. I saw the Student-Parent set of videos listed on the site, maybe there is something in those.  Thanks again,
Nils

Yes, this will require a little bit more work. Please post screen images of both your parent table and child table in design view.

Hi Sami,  Sorry I am not receiving any notices of your replies and just checked back now and saw this.
Here is a screen shot.  Let me know if this helps.

Your upload system is not working at all.   First, the file size limit is tiny, so I scaled down my screenshots to accommodate.  Then I am getting the error that only jpg gif and png files allowed which is what I am trying to upload.  Please advise.

Seems spaces in screenshot file names does not work...  I renamed and upload is good now. Thanks.

Value From a Form

Thank you so much Kevin!  That is what I needed.  It was quite a bit more complicated than the video, but it got me there finally.
Best,
Nils