need help in writing Docmd

[lamha]

I have a command button on a form that has 2 subforms. What I need it to do is to load frmData (but not visible)where its Item_Skey = subform1.Item_Skey, Item_State = mainform.Item_State, and Reading_Type = subform2.Reading_Type. Then unload frmData and show frmGraph (OR show Graph then unload frmData???).
Thanks for any help in advance.

 

[jordan0904]

did you try an if statement...
if item_skey = subform.item_skey then
docmd.open acform,("nameofform")
docmd.close acform,("nameofforme")
endif