Re: Form change when record added

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Something that might help is to add a command button to "Save Record".
In the Click event of that command button put the line
me.dirty = false

That might confuse your users who might then assume that records won't
be saved unless an explicit "save" command is given.

The question arises: why do you want to continue to edit a record
after you have just saved it?

Another method that works is simply to use the navigation buttons at
the bottom of the window.

One other thing that could cause problems would be the form
properties.

HTH
--
-Larry-
--

"luis_a_roman via AccessMonster.com" <u41449@uwe> wrote in message
news:89976147f5197@xxxxxx
I have a form that enable me to add a record with several fields.
When I add
the last record or when the last field is entered the record in the
form
change.

Is there anyway that I can refresh the form with the record added?
Could I
modified the record RowSource with the appropriate SQL statement? Or
should I
execute another Docmd.OpenForm with a filter to get the record
added?

Want options to understand how does it work? Specially, want to
understand
the impact that the RowSource has when modified in a form?

Thank you for guidance and collaboration with this question.

Luis

--
Message posted via AccessMonster.com

http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200809/1



.



Relevant Pages

  • Re: Unwanted tablelist scrolling during cellconfigure
    ... explicitly call the 'see' command, ... It also doesn't happen for a partially visible row at the bottom of the ... I haven't been able to reproduce your problem. ... I am also somewhat surprised to hear that the topmost row in the window gets partially obscured. ...
    (comp.lang.tcl)
  • Re: Great SWT Program
    ... mostly solve the blind-typing problem that I definitely recall emacs ... Except of course that you need to know some arcane command language ... Hitting tab should insert a tab ... one-line "window" in which the rest of what I type appears, ...
    (comp.lang.java.programmer)
  • Re: Printer Control and Print/Preview Problems
    ... to be appended to the report print stream. ... or "Print" with the DoCmd.OpenReport command, ... still open preview window. ... > following that with an OpenReport using acNormal. ...
    (microsoft.public.access.reports)
  • Re: Dim RetVal
    ... "Jay Freedman" wrote in message ... The reason is that without the quotes, the command processor sees the ... In the command window, first type ... This *should* have exactly the same effect as the macro. ...
    (microsoft.public.word.vba.beginners)
  • Re: playtime for spare PCs -Jeff Gaines.
    ... The Black Window is the "Command Prompt Window" & that wouldn't have ... The Window Opens up & Flashes up ... I would expect there to be 2 User Accounts (on a WinXP ...
    (uk.people.silversurfers)