PC Review


Reply
Thread Tools Rate Thread

pop up will not requery

 
 
deb
Guest
Posts: n/a
 
      16th Sep 2009
I have a form called f9ProjectMaster that updates and adds new records to the
tProject table. On this form is a button used to find records called list9b
with the below code.
Dim stDocName As String
Dim stLinkCriteria As String

If Forms!f9ProjectMaster.Dirty Then
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
' Me.Dirty = True
Forms!f9ProjectMasterSub.Requery
Me.Refresh
End If

stDocName = "f9ProjGoTo"
DoCmd.OpenForm stDocName, , , stLinkCriteria

This brings up a pop up that the user selects the project to find and
display the record in the f9ProjectMaster form. The pop up has the below
code..
Forms!f9ProjectMasterSub.Requery
Me.Requery


Dim rst As DAO.Recordset

' Store the recordset for the form.
Set rst = Forms!f9ProjectMasterSub.RecordsetClone

' Locate the record for the selected.

rst.FindFirst "ProjMasterID = " & List9b

' Set the form's Bookmark property to move to the record.
Forms!f9ProjectMasterSub.Bookmark = rst.Bookmark

' Close the dialog box.
DoCmd.Close acForm, "f9ProjGoTo"

When create a new record or update a record. the pop up form does not
display the changes unless I close the f9ProjectMaster form and reopen. I
have tried to requery everything but no luck.
I opened the table before I click the button to make sure the changed data
is in the table and it was, but the pop up query only shows the old data.
I'm confused.

Any suggestions?
--
deb
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
pop up will not requery deb Microsoft Access Form Coding 0 16th Sep 2009 07:52 PM
POP pOp PoP POP pOp PoP 0021275831620 sofiane Windows XP Internet Explorer 1 20th Dec 2006 05:11 AM
Requery issue : Application closes on form.requery.... =?Utf-8?B?c3VyeWE=?= Microsoft Access Form Coding 3 6th Nov 2006 09:58 PM
Requery the 1st requery result which displayed in form vincentt via AccessMonster.com Microsoft Access 2 31st Aug 2006 03:49 AM
Requery without using Me.Requery? Daniel Microsoft Access VBA Modules 3 28th Oct 2003 01:37 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:40 PM.