Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by cahigg

  1. cahigg

    displaying new record on a form after adding record with popup form

    Thanks alot! I went with the DoCmd option as I was having trouble using recordsets on another part of the app (now I know why: DAO wasn't installed!!!) I got it working the way it should and I also used similar code to allow users to search for a VN number across all facilities in the parent...
  2. cahigg

    displaying new record on a form after adding record with popup form

    One more thing, where do I put the code to requery, setfocus,etc.? Do I put it in the popup (frmAddNewVN) form that creates the new records (which is an on_click event for the Save button that creates the new vn_number, adds related records to the vn_actions table and then closes frmAddNewVN)...
  3. cahigg

    displaying new record on a form after adding record with popup form

    Thanks for the help all. Here are the form names: frmVNTracking - main form with subform subfrmVN - subform on frmVNTracking with subform tabVNactions - subform on subfrmVN (actually there are three tabs each with a subform) the popup form is frmAddNewVN I used CautionMP's suggestion and...
  4. cahigg

    displaying new record on a form after adding record with popup form

    I have a form with two nested subforms. On the first subform, there is an "Add New" button that will add a new record to the first child form and records to the child's child form. I need to requery to main for to include the new records, but I can't figure out how to set the record selector...
See more

Part and Inventory Search

Back
Top