Hi all,
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 to each other by a field I called po_no(automatic no. from the SQL Server)
On this form I have to add the parent part first and then the child part. The po_no(which is the connection between 2 views) does not show up until I have this code(on the buttonset)
*******
if (thisform.PO_NO_ID1.value = 0) and
(thisform.buttonset1.cmdadd.caption = "\
=requery()
thisform.refresh()
endif
dodefault()
*******
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 added(from parent part), then I can add more child records.
Any suggestions would be appreciated.
Thanks in advance.