473,394 Members | 1,960 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Changes don't appear in my subform when I enter a new record

2
I have a form that contains the user interface, and there I have an independent subform that reads data from a form. When I double click to a record, a second subform pops up and I enter the new details there

The problem I have is when I add a new record and click the save button I created, the subform doesn't reflect the changes. I have to close the form of the UI and open it again to see the new record, or go to the table

How can I solve this?

Thank you!!!
Sep 29 '14 #1

✓ answered by Seth Schrock

In your second form (the one where enter the new record), add an On_Close event procedure. In the event, requery the form that has all the data.

2 920
Seth Schrock
2,965 Expert 2GB
In your second form (the one where enter the new record), add an On_Close event procedure. In the event, requery the form that has all the data.
Sep 29 '14 #2
MSTC
2
Thank you! Works like charm
Sep 30 '14 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Bob | last post by:
Hi Everybody I have a form called frmListBox that is connected to a table tblListBox. This is opened from a form called "frmInvoiceOrder" which has a subform called "zfrmInvoiceOrder" and...
11
by: Joe | last post by:
Hello All, I have an ASP.NET page with one Textbox (SearchTextBox) and one ImageButton (SearchButton) server controls. The user can type search text in SearchTextBox and click SearchButton and...
2
by: K E Senthil Kumar | last post by:
I use this code to find a record. I want to beep a sound when no record is found. But even when the record is found, the beep is sounding. What is wrong with the code here Private Sub...
4
by: rczuba | last post by:
Problem: Creating a Default Value for a field in a subform when a field in the subform & form match. I'm trying to create a payroll database for a small home business that I have that has had...
2
by: angi35 | last post by:
I hope this is an easy question for someone out there. In Access 2000…I have a MainForm with a tab control (MAIN TABS) with 7 tabs. Within each tab is a SubForm. Within each SubForm is a tab...
1
by: Crombam | last post by:
Hi to all, After searching the net for a couple of hours I just have to ask the question. How can I close a report with a subform (Pivot Chart) when this Pivot Chart is having no data? ...
5
by: AccessBeetle | last post by:
I have asked this question before and I got the answer but now there is an extension in User's requirement. Here is the issue. On a form there is a timestamp field, which saves the time when the...
8
by: Erik Pen | last post by:
My main form has several subforms which display the results of queries. I want to display a message in a subform when it's query is empty indicating that there are no records meeting the form's...
2
by: tamchar | last post by:
I have a form with subform. When the main form is generated the number series of document on field (Called RegNum), and I wont that number series is auto updated to field (called RegNumD) on subform....
5
by: chip0105 | last post by:
When a form is opened fields are locked. When a new record is added (by pressing an add new record button), fields are unlocked. When the record is saved the fields are then locked again. ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.