|
|
Subforms won't refresh after new record
Access 2003, XP Pro
I have a main form with two separate subforms. I view various records by
clicking on some list boxes.
To add a new record, I select Records, Data Entry.
I then
(1) Make a selection in a combo on the main form.
(2) Make a selection in a combo and enter some text in a textbox on subform1
(3) Make a selection in a combo on subform2
Subform2 has some code on the After Update event that saves the new record
and goes to a previously selected record in cbo1 on the main form (cbo2 has
code on the After Update event to go to that record).
Here's the code on subform2
If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord
Me.Parent.Requery
Me.Parent!subform1.Form.Requery
Me.Requery
Me.Parent!cbo2= Me.Parent!cbo1
Me.Parent.Refresh
Me.Parent!subform.Form.Refresh
Me.Refresh
The problem is the main form then displays the correct record, but the two
subforms remain blank until I close and reopen the form.
I have also tried solutions without code just by clicking to another record,
but then the main form once again displays the correct record, but then the
subforms display the new data and won't refresh until I close and reopen the
form.
Thank you
Peter
|
|
0
|
|
|
|
Reply
|
Utf
|
11/17/2009 6:16:31 AM |
|
Sorry this question is here twice. When It didn't appear in the forums after
half an hour, I reposted. Post answers to the question immediately above.
Thanks
|
|
1
|
|
|
|
Reply
|
Utf
|
11/18/2009 1:58:02 AM
|
|
Sorry--The post immediately below is the one
|
|
1
|
|
|
|
Reply
|
Utf
|
11/18/2009 2:01:01 AM
|
|
Ignore this thread, I have re-posted, hopefully a little more clearly.
|
|
1
|
|
|
|
Reply
|
Utf
|
11/19/2009 2:51:02 AM
|
|
|
3 Replies
640 Views
(page loaded in 0.104 seconds)
Similiar Articles: New Record Refresh/Requery/ShowAllRecords - microsoft.public ...Refresh after New Record Added - microsoft.public.access.forms ... Refresh after New Record Added - microsoft.public.access.forms ... How to Requery a form without losing ... If No Records in Subform, Parent Form Record doesn't display ...> > If I don't have any records in a subform, the ... Refresh parent form when subform deletes records If No Records in Subform, Parent Form Record doesn't display: Melissa ... Popup Form Launched from SubForm Button and New Record Sync ...Can't Enter New Record in Subform - microsoft.public ... within the main form, my subform won't ... MS Access: Refresh the contents of a subform whenever the record ... ... Show last 'X' records in a subform - microsoft.public ...... the user uses to input data to create new records. these records are displayed in a subform ... based on the table: However the user won't be able to see the records ... Can't Enter New Record in Subform - microsoft.public.access ...... and everything, but when I try to entry new records it won't let ... How to restart tab index on subform after moving to next record ... Can't Enter New Record in Subform ... OK my subform is not entering saving the key from the master ...Subform won't create new record (Access 2007): Microsoft, Access, 2007 ... MS Access: Refresh the contents of a subform whenever the record ... Click on the OK button. Tabbing Out of Continuous Subform - microsoft.public.access.forms ...Is there a way to set a subform (continuous) so that after the last record (in the subform) is entered, and the user has tabbed to the new ... some other control so it won't ... auto update of a subform - microsoft.public.accesssubform - new record entry - microsoft.public ... Subforms won't show all data from table ... MS Access: Refresh the contents of a subform whenever the record ... unbound textbox value derived from subform - microsoft.public ...It works, BUT I can't seem to get txtLatestDate to refresh as soon as I change an existing date in the subform ... upon picking a new value ... for each > related record ... Refresh Subform2 Query when Subform1 Control Changes - microsoft ...Why won't it work? -- Paul C., thanks. ... Microsoft: Access Forms - Refresh subform on tab control ... It would be nice to have it refresh and show new changes ... Subforms won't refresh after new record DataBaseAccess 2003, XP Pro I have a main form with two separate subforms. I view various records by clicking on some list boxes. To add a new record, I select AfterUpdate event won't refresh subform!AfterUpdate event won't refresh subform! ... in the dropdown list in the first subform. As I said, this happens for the first new record I add after ... Access 2007 unbound form won't refresh with recordsource update ...MS Access; Access Forms; Access 2007 unbound form won't refresh … ... compacting/repairing, mdb/accb etc. nothing worked. the subform always shows just the new record ... MS Access: Refresh the contents of a subform whenever the record ...In Access 2003/XP/2000/97, how do I refresh the contents of a subform whenever the record in the main form changes? Access subform will not refresh - Access World ForumsThe problem is that the subforms on the main form will not refresh each time the user chooses a new record on the main form. If I change to a new record on the main form ... 7/23/2012 9:19:52 AM
|
|
|
|
|
|
|
|
|