Help!
I am working on a parent child form which is used to make purchase orders. I use 2 views for this form(one I called purchase_order, the 2nd is purchase_item) They are related by a field I called po_no(automatic no)
When I make a new PO, I click on "Add" button, but the po_no(from parent part) does not show up until I have this code(on the buttonset)
*******
do case
case thisform.buttonset1.cmdadd.caption = "\
dodefault()
case thisform.buttonset1.cmdadd.caption = "\ if thisform.PO_NO_ID1.value = 0
=requery()
thisform.refresh()
dodefault()
else
dodefault()
endif
endcase
*******
I do "requery" to get the po_no which is needed for the child part. But my problem here is after I requery, the first record(on the parent part) always comes up on the screen. I just want to stay at the record I just add(from parent part), then I can add child records.
Any suggestions would be appreciated.
Thanks in advance.