Added record not showing in navigation frm (1 Viewer)

foxtet

Registered User.
Local time
Tomorrow, 00:41
Joined
May 21, 2011
Messages
126
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

Registered User.
Local time
Tomorrow, 00:41
Joined
May 21, 2011
Messages
126
Why the added records does not reflect in sub form which is in navigation form

any help is appreciated.

foxtet
 

Attachments

arnelgp

error reading drive A:
Local time
Tomorrow, 04:41
Joined
May 7, 2009
Messages
9,349
my good friend you may try this. i hope nobody challenge me this time.
 

Attachments

RuralGuy

AWF VIP
Local time
Today, 14:41
Joined
Jul 2, 2005
Messages
13,826
Isn't challenge a good thing? It improves the product, right? Unless it was nasty of course.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom