473,320 Members | 2,035 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,320 software developers and data experts.

Subform: Can't move to next rec once something is edited?

I *know* I've seen this before but can't remember where.

Got a subform - pretty simple, actually. It's lined to a work table that
contains comments related to a mutual fund.

No problem loading it, shows all the comments.

But once I edit a comment - say type "x" after the last word - I cannot move to
the next record. I can click on another field in the same record, and focus
moves... but when I click on a field in the next record, nothing happens - focus
remains on the changed record.

Nothing shows on the Status Bar except a brief "Calculating..." message.
Anybody been here?
--
PeteCresswell
Nov 13 '05 #1
6 1842
Only thing I can think of is

1. check to make sure that duplicates are allowed in the subform for
the linked fields
2. Make sure the linked fields are correct
That's all I can think of based on the info you provided.

Nov 13 '05 #2
"(Pete Cresswell)" <x@y.z.invalid> wrote
Got a subform - pretty simple, actually. It's lined to a work table that
contains comments related to a mutual fund.

No problem loading it, shows all the comments.

But once I edit a comment - say type "x" after the last word - I cannot
move to
the next record. I can click on another field in the same record, and
focus
moves... but when I click on a field in the next record, nothing happens -
focus
remains on the changed record.

Nothing shows on the Status Bar except a brief "Calculating..." message.

It sounds like focus actually leaves that record, then goes to the main
form, at which point something happens that kicks focus back to the subform.

--
Darryl Kerkeslager

Power corrupts.
Absolute power corrupts absolutely.
Knowledge is power.
See www.adcritic.com/interactive/view.php?id=5927
Nov 13 '05 #3
(Pete Cresswell) wrote:
I *know* I've seen this before but can't remember where.

Got a subform - pretty simple, actually. It's lined to a work table that
contains comments related to a mutual fund.

No problem loading it, shows all the comments.

But once I edit a comment - say type "x" after the last word - I cannot move to
the next record. I can click on another field in the same record, and focus
moves... but when I click on a field in the next record, nothing happens - focus
remains on the changed record.

Nothing shows on the Status Bar except a brief "Calculating..." message.
Anybody been here?


Is the record being saved? If there's a reason it's not being saved then
it won't allow you to leave it, check in Form_BeforeUpdate() or for any
validation rules that may be a bit complex and maybe a spurious
"DoCmd.SetWarnings False" that may have turned off the warning telling
you the record cannot be saved.

--
[Oo=w=oO]

Nov 13 '05 #4
On Mon, 28 Mar 2005 22:49:53 -0500, "Darryl Kerkeslager"
<ke*********@comcast.net> wrote:
It sounds like focus actually leaves that record, then goes to the main
form, at which point something happens that kicks focus back to the subform.


That makes the most sense so far - especially bc of the "Calculating"
notice in the status bar.

I tried editing the RS behind it and no problem - so that seems to let
..ValidationRule off the hook....
Nov 13 '05 #5
On Tue, 29 Mar 2005 07:11:03 -0500, PeteCresswell <x@y.z.Invalid>
wrote:

I tried editing the RS behind it and no problem - so that seems to let
.ValidationRule off the hook....

I also tried loading up the work table via normal operation of the
parent form, closing the parent, and then just opening up the subform
by itself. The problem did not manifest itself - adding weight to
your idea.

Also, this subform has .AllowEdits, .AllowDeletions, and
..AllowAdditions=False when it is first opened. I don't set these =
True until the parent form is put into "Edit" mode..... yet when the
parent form is still in "Browse" mode, that extra empty record that
appears when the form has .AllowAdditions=True is there and if I check
that property in an Immediate window, it is mysteriously = True.
Seems like something weird is going on in the parent form....Just
applied Office 2003 SP1 in hopes....but to no avail...
Nov 13 '05 #6
On Tue, 29 Mar 2005 11:06:43 -0500, PeteCresswell <x@y.z.Invalid>
wrote:
Seems like something weird is going on in the parent form


Had a Form_AfterUpdate() in the child form - put there, I'd guess just
on GPs....because each editable control on the form has it's own
AfterUpdate() event.

Removed Form_AfterUpdate() and all was well. Found the same
situation on two other subforms. Same fix, same results.

Each one was invoking a "SetDirty" type routine in the parent - but
why doing that in Form_AfterUpdate() was messing things up but doing
it in individual control AfterUpdate()s was not is still a mystery.

Oh well...
Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: Rey | last post by:
Howdy all. Appreciate your help with several problems I'm having: I'm trying to determine if the Visit subform (subformVisits) has a new record or been changed, i.e. dirty. The form that...
2
by: John Baker | last post by:
Hi: I have a sub form which i would like to show all the records selected from a table. There may well be over 100 of them. For reasons I cant fathom, the form will only show six, and then...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
4
by: Dave Boyd | last post by:
Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the...
5
by: PC Datasheet | last post by:
Is there a way to page through a subform using PageDown and PageUp? Thanks! Steve PC Datasheet
3
by: dataeagle | last post by:
In the 'On open' event of a main form, I need to check the values of a nested subform (i.e. subform of a subform). I am able to pass the first value, and even though it goes through each time, it...
1
by: google | last post by:
I have a form with several subforms. Users enter the data, then on the parent there is a command button that runs code to generate a .pdf document from a report based on the data they are working...
9
by: Ecohouse | last post by:
I have a main form with two subforms. The first subform has the child link to the main form identity key. subform1 - Master Field: SK Child Field: TrainingMasterSK The second subform has a...
1
by: stuart | last post by:
I have a list of records in a subform that a user can either edit or delete. This is an unbound form. If the user deletes a record, I want to refresh the form, and then position the cursor on the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.