from/subform/Add New record

  • Thread starter Thread starter Vickie English via AccessMonster.com
  • Start date Start date
V

Vickie English via AccessMonster.com

Hi,
I'm new at this and I hope someone can help me. I have a subform within a
form both of which I created from separate tables. I also have a third form
which I created using fields fomr the subform table.
I'm using the 3rd form for data entry; I'd like the record I select or
endter in the 3rd form to appear in the subform. Could someone please give
me some ideas?
I have tried everything I can thin of but the entries do not show in my
subform.
I do have a common id fields linking the main form and the subform and the
subform is continuous. Please help.
VE
 
Use the AfterUpdate event of the 3rd form to Requery the subform:

Private Sub Form_AfterUpdate()
Forms![YourMainFormName]![YourSubformContolName].Form.Requery
End Sub

You may want to test if YourMainFormName is still open before doing this,
and use the AfterDelConfirm event of the 3rd form as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Hello Allen,

Thank you very much for your help. I'm afraid I have only a sketchy idea
about VBA so I'm not quite sure how to go about the last part of your
reply:

.......use the AfterDelConfirm event of the 3rd form as well.

could you please explain a bit further and also do you have any idea about
the code? Thanks again.
VE
 
Back
Top