Unanswered: open form with recordset from other form
Hi everyone thanks for taking the time to read this!
I'm very new to access and code and I'm definitely stucked now.
I would like to do the following: I have a Form "tanks query" that contains multiple subforms one of them beeing "1-5". These subforms are based on crosstab queries (for display reasons). If I do click on field "1" I would like to open another form "frmti" containing a subset of records with more information on. The link is based on the text entry of "1" that corresponds to text entry in the field "Cell line name" several records having a matching entry. Finally form "tank query" should be closed. I have tried the OpenForm Cmd but somehow I seem to make somthing wrong. Many thanks in advance Sam