Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-13-2015, 01:57 AM   #1
foxtet
Registered User
 
Join Date: May 2011
Posts: 126
Thanks: 48
Thanked 0 Times in 0 Posts
foxtet is on a distinguished road
Added record not showing in navigation frm

In the database I have problem in showing the added data to the form that is in navigation form.

I have used the following code in the after update event of frmAddNew
Private Sub Form_AfterUpdate()

Dim lngSNO As Long
Dim frm As Form
Dim rs As DAO.Recordset
If IsFormLoaded("frmCargoSearch") Then
Set frm = Forms("frmCargoSearch")("tblCargoMaster subform").Form
lngSNO = frm!Sno
frm.Requery
Set rs = frm.RecordsetClone
rs.FindFirst "[sno] = " & lngSNO
If Not rs.NoMatch Then frm.Bookmark = rs.Bookmark
rs.Close
Set rs = Nothing
Set frm = Nothing
End If
End Sub

When try to add in frm search it works but in navigation form it doesn’t.
Need your help to overcome this

Thank you
foxtet

foxtet is offline   Reply With Quote
Old 12-13-2015, 04:53 AM   #2
foxtet
Registered User
 
Join Date: May 2011
Posts: 126
Thanks: 48
Thanked 0 Times in 0 Posts
foxtet is on a distinguished road
Re: Added record not showing in navigation frm

Why the added records does not reflect in sub form which is in navigation form

any help is appreciated.

foxtet
Attached Files
File Type: zip NavigationForm.zip (1.24 MB, 33 views)
foxtet is offline   Reply With Quote
Old 12-13-2015, 06:40 AM   #3
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,434
Thanks: 68
Thanked 2,709 Times in 2,594 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Added record not showing in navigation frm

my good friend you may try this. i hope nobody challenge me this time.
Attached Files
File Type: zip NavigationForm.zip (409.6 KB, 41 views)

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
foxtet (12-13-2015)
Old 12-13-2015, 07:14 AM   #4
RuralGuy
AWF VIP
 
RuralGuy's Avatar
 
Join Date: Jul 2005
Location: @ 8300' in the Colorado Rockies
Posts: 13,820
Thanks: 7
Thanked 311 Times in 301 Posts
RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice
Re: Added record not showing in navigation frm

Isn't challenge a good thing? It improves the product, right? Unless it was nasty of course.
__________________
(RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, Win10 Pro
Please post back to this Forum so all may benefit.
Teaching is not filling a bucket but lighting a fire.
RuralGuy is offline   Reply With Quote
The Following User Says Thank You to RuralGuy For This Useful Post:
Uncle Gizmo (05-05-2017)
Old 12-13-2015, 09:23 PM   #5
foxtet
Registered User
 
Join Date: May 2011
Posts: 126
Thanks: 48
Thanked 0 Times in 0 Posts
foxtet is on a distinguished road
Re: Added record not showing in navigation frm

Quote:
Originally Posted by arnelgp View Post
my good friend you may try this. i hope nobody challenge me this time.
It's really a great help. You have excellent solution skills

Thank you!

foxtet

foxtet is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Treeview navigation problem after a new added node suleymanera Modules & VBA 0 07-08-2015 08:16 AM
Treeview Navigation Problem after a new added node suleymanera Modules & VBA 0 07-08-2015 02:39 AM
Query not showing new records added though they exist in table. Ahmsv1 Queries 20 06-26-2013 01:24 PM
Query not showing newly added records Richardabichahla Queries 14 06-23-2010 10:48 PM
Question Record Count Total Not Showing in navigation bar Nannab General 2 03-17-2010 04:44 AM




All times are GMT -8. The time now is 07:53 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World