How do I see new data immediately in a form ?

[acnovice]

Hi,

I have a form called "CustInquiry" that has a Tab Control with 2 pages in it. One for "InquiryStatus"--schedule, another for "InquiryDetails"--data entry.
After I enter data to "InquiryDetails, schedule shows up to "InquiryStatus".

However, the data that I just entered to "InquiryDetails" doesn't show up immediately from "InquiryStatus".

I have to close the form "CustInquiry" and reopen it...then new data shows up "InquiryStatus".

How do I see data that I just entered immediately from a form without close the form ?

I'm using subform in "InquiryStatus" and Record source from "query" that I created.

 

[PHV]

Have you tried the classical methods ?
Refresh
Requery
RecordSource = RecordSource
...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[VBslammer]

In the AfterUpdate event of the InquiryDetails subform (is there a subform on that page?), tell the parent form to requery the status subform:

Private Sub Form_AfterUpdate()
  Forms!CustInquiry!InquiryStatus.Form.Requery
End Sub

*** If you use the Refresh action, any new records won't show up and deleted records won't disappear.

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[acnovice]

Hi Guys,

It works fine... thank you.
You guys have a good day today.