Re: moving to the next record in forms

Tech-Archive recommends: Fix windows errors by optimizing your registry



On Wed, 11 Jan 2006 09:05:02 -0800, Miguel Vivar
<MiguelVivar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I have created three forms (I will call the main form "old form" and the
>others "new forms). The old form has questions with the "check box" option,
>which once these questions are answered with either "yes" or "no" either one
>new form opens or the other new form opens or both opens (I created a macro
>that does that). However, once these new forms open and their respective
>questions are answered they do not go to the following record once I go to
>the following record on the old form. How can I make the new forms go to the
>next record automatically once I go the next record on the old form?
>
>Miguel

With difficulty!

Why *three forms*? What are their Recordsources? This seems a very
complex way to do things. Can you perhaps use a single Form with tab
pages for the different questions? What is the structure of your
tables?

John W. Vinson[MVP]
.



Relevant Pages

  • Re: Update Event
    ... Try a Refresh just before opening the second form. ... When this button is clicked another form opens up called ... The problem is if I tab to the cmd_notes button after entering the status, ...
    (microsoft.public.access.formscoding)
  • Re: Closing a form Error
    ... the next form opens right away and so on. ... the tab, I simply change the source object for the subform. ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ... Is there a way to close a form when any control on the form loses ...
    (microsoft.public.access.formscoding)
  • Re: Tab does not display all info
    ... Duane Hookom ... MS Access MVP ... form opens, 5 of the fields are visible. ... When I tab from to field 6, ...
    (microsoft.public.access.forms)
  • Update Event
    ... In this form are two combo boxes, ... When this button is clicked another form opens up called ... The problem is if I tab to the cmd_notes button after entering the status, ... selections are there. ...
    (microsoft.public.access.formscoding)
  • Re: Set Focus to first field
    ... (no e-mails, please!) ... I checked all my tab settings they seem correct. ... > For some reason the form opens at tab position 7 rather than tab position ...
    (microsoft.public.access.forms)