Updating form after adding record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform whose record source is a query. The subform lists all
persons associated with a case. (The main form has the case information) I
open another form to add a person to a case and when I close the new form
after adding the person to the bridge table I want my subform to update and
show the new person I just added. I tried using some requery commands
unsuccessfully. my subform has four textboxes it needs to refresh and
display. Any suggestions?
 
Hi, I have something similar and had the same battle. If its what I think it
is, add this to your button that closes the form where you have just added
the person. Its just the refresh command and activates every time you close
the adding person form. Works for me anyway.

Docmd.Close
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

get sum from subform on button(on main for)click 3
GoToRecord for a subform 4
Access Main form/Subform Navigation 0
Access form update/Requery? 1
Go to the first record in subform 1
Create Mulitple Records based on a Form Control: Error Invalid Ent 6
How to update main form when closing pop up form and... 6
Updates in forms and subforms 1

Back
Top