F
Farooq Sheri
I have a main form which has the following:
* main form's record source is table Tab1.
* main form has an unbounded combo box (Combo1). Its row source is table Tab2
*main form has four subforms each based on a query and each using a Combo1
value criteria.
*main form has two unbounded text boxes Text1 and Text2. These are used to
display values from a table Tab3 if matching Combo1 is found in Tab3.
Otherwise
these display nothing. I use
Set rs = Me.Recordset.Clone
rs.FindFirst "[TRLG] = '" & Me![Combo35] & "'"
Me.Bookmark = rs.Bookmark
type statement in code to find value in Tab3.
When Combo1 matching value is found in Tab3 my application works correctly.
However if no match is found then none of the subform fields show any values.
All I can see is the outline of subforms and field captions within these.
Please note that there is no link between Text1 / Text2 / Tab3 with any of
the subforms / queries and vice versa. The only thing in common is the Combo1
value. Also note that the queries linked to subforms definitely have atleast
one value corresponding to Comb1 value.
I want to application to show subforms field values even though Text1 &
Text2 have nothing to show (no match found in Tab3 for Combo1 value).
Any help.
* main form's record source is table Tab1.
* main form has an unbounded combo box (Combo1). Its row source is table Tab2
*main form has four subforms each based on a query and each using a Combo1
value criteria.
*main form has two unbounded text boxes Text1 and Text2. These are used to
display values from a table Tab3 if matching Combo1 is found in Tab3.
Otherwise
these display nothing. I use
Set rs = Me.Recordset.Clone
rs.FindFirst "[TRLG] = '" & Me![Combo35] & "'"
Me.Bookmark = rs.Bookmark
type statement in code to find value in Tab3.
When Combo1 matching value is found in Tab3 my application works correctly.
However if no match is found then none of the subform fields show any values.
All I can see is the outline of subforms and field captions within these.
Please note that there is no link between Text1 / Text2 / Tab3 with any of
the subforms / queries and vice versa. The only thing in common is the Combo1
value. Also note that the queries linked to subforms definitely have atleast
one value corresponding to Comb1 value.
I want to application to show subforms field values even though Text1 &
Text2 have nothing to show (no match found in Tab3 for Combo1 value).
Any help.