D
Desert Bear
I have a main form, with a control that contains the ID of the records I want to display on the subform.
The subform is based on a query which picks up the ID from a combo box (this works)
A new requirement meant the ID could come from two different sources--the combo box and another.
I established a control which is set correctly to the ID by the combo box or the other source.
when I changed the query to pick up the ID from the text box (change) instead of the combo box (which works), the subform will flash into view for a split second and then disappear.
The query works correctly off the text box. If I bring up the main form, make selections, and then open the query, it selects the correct records using the ID from the text box.
Why is the subform disappearing, and how do I fix it? The subform didn't change. It's still based on the same query which has the same name.
The subform is based on a query which picks up the ID from a combo box (this works)
A new requirement meant the ID could come from two different sources--the combo box and another.
I established a control which is set correctly to the ID by the combo box or the other source.
when I changed the query to pick up the ID from the text box (change) instead of the combo box (which works), the subform will flash into view for a split second and then disappear.
The query works correctly off the text box. If I bring up the main form, make selections, and then open the query, it selects the correct records using the ID from the text box.
Why is the subform disappearing, and how do I fix it? The subform didn't change. It's still based on the same query which has the same name.