I've got a form (frmViewRequests) that has the DefaultView set to
Continuous (that's how I want it ... so far, so good)
On this form, I've got a "Create New Request" Button that opens another
form (frmCreateRequest).
When the request has been created, the frmCreateRequest form is closed,
bringing me back to frmViewRequests.
Here's the problem ... the number of "individual forms" never changes,
therefore, if I had 2 records in my table, the form would have given me
2 "individual forms" within my "continuous" form. If I add a record,
there are still only 2 "individual forms". If I close my form and open
it again, it opens with 3 "individual forms". If I delete one, the
"individual form" of the record I deleted is still there with "#Deleted"
in the fields for that "individual form".
I want the frmViewRequests to instantaneously reflect the new entry ...
just as the underlying table does.
Any and all help is appreciated.
Sorry about the bad sentence construction (I was never schooled in
English) 1 5189
Requery frmViewRequests.
Refresh (if that's what you're doing now) just updates existing records, but
doesn't take account of deleted or inserted records.
HTH, Mike MacSween
"Lauzon, Robert: IHAB" <La***********@ic.gc.ca> wrote in message
news:3E**************************************@pubg ate-01.ic.gc.ca... I've got a form (frmViewRequests) that has the DefaultView set to Continuous (that's how I want it ... so far, so good)
On this form, I've got a "Create New Request" Button that opens another form (frmCreateRequest).
When the request has been created, the frmCreateRequest form is closed, bringing me back to frmViewRequests.
Here's the problem ... the number of "individual forms" never changes, therefore, if I had 2 records in my table, the form would have given me 2 "individual forms" within my "continuous" form. If I add a record, there are still only 2 "individual forms". If I close my form and open it again, it opens with 3 "individual forms". If I delete one, the "individual form" of the record I deleted is still there with "#Deleted" in the fields for that "individual form".
I want the frmViewRequests to instantaneously reflect the new entry ... just as the underlying table does.
Any and all help is appreciated.
Sorry about the bad sentence construction (I was never schooled in English) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Damian |
last post by:
Hi.
Is there a way to programatically populate a continuous form?
I have an array of descriptions that I want to display in the
continuous form and I have a textbox on the form called...
|
by: Richard Hollenbeck |
last post by:
I have the following query in my form's code:
Private Function Get_Data(fieldNum As Integer)
Dim strSQL As String
Dim db As DAO.Database
Dim rs As DAO.Recordset
strSQL = "SELECT & "", "" & ...
|
by: debbie |
last post by:
Well I'm finally trying out class modules...I have a great book I'm
using but its ADO and I use DAO so it's a challenge for me...I've
looked most of today, in my book and here but can not find an...
|
by: Jeremy Wallace |
last post by:
Folks,
Here's a write-up I did for our developer wiki. I don't know if the
whole rest of the world has already figured out how to do this, but I
hadn't ever seen it implemented, and had spent a...
|
by: Welie |
last post by:
I am having a problem an it's driving me crazy, I hope someone can
correct my technique. I can't find a pattern and don't know where to
look to debug this. The problem is on a continuous form, the...
|
by: Michael R |
last post by:
Searching the net I've found a simple technique to add row numbers and alternate colors (for the even and the uneven row) to a continuous form.
1st step: Create a textbox, send it to background...
|
by: virtualgreek |
last post by:
Dear all,
I have a scenario that is driving me nuts. (MS Access 2003)
I have a form/subform (Continuous form) where it gets its data from tables Order and Order_Details.
In the footer...
|
by: Jollywg |
last post by:
I have a continuous form with 5 columns (Qty, PartNum, Desc, ItemCost, TotalCos). At the bottom of the form i have a field labeled Invoice Total. Right now the Invoice Total is totaling everything...
|
by: bkberg05 |
last post by:
Hi - I have a field called Sequence on a continuous subform. The Sequence field belongs to a table called Project_Draw. This table has many 'Draw' records for each 'Project' record. So then the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |