Moving Between Records

[Guest]

Hi,

I have a database with a whole series of information stored within it and a
whole series of forms which the user can use to move around within the
database.

Some of these forms are previous and next phases to the current form and
therefore contain the same record names and titles. Just different activities
and tasks.

Is there a way that I can move from one form to another (one phase to
another) whilst keeping on the same record number?

For example : Being on record 100 on one form and then moving to the next
form and still being on record 100 rather than refering back to record 1?

Many Thanks,

Kieron White

 

[Yumex85]

I don´t know if i understood well how your form is designed. Are you
using a record navigator to move around? If you´re using a record
navigator for instance, you could make this record navigation manual,
for better control.
DoCmd.GoToRecord , , acNext to go to next record
DoCmd.GoToRecord , , acPrevious to go back and so on. You could insert
those codes behind a button, and only when user presses this button
you go to the next record, otherwise u just stay in the same record,
and show another information calling the same kind of form with
different fields.

 

[Guest]

Not sure if this will help but it was an answer I got about moving around
from a subform to a normal form but on the same record

It goes on the double click event of a field property/ or possibly a control
button maybe - good luck
This is the syntax

If [myUniqueField is a numeric field
DoCmd.OpenForm "jobdata", , , "[myUniqueField] = " & [myUniqueField]

If [myUniqueField is a textfield
DoCmd.OpenForm "jobdata", , , "[myUniqueField] = '" & [myUniqueField] & "'"

If [myUniqueField is a date field
DoCmd.OpenForm "jobdata", , , "[myUniqueField] = #" & [myUniqueField] & "#"

On the left hand side of the = sign, [myUniqueField] is a field name on the
form being opened. On the right it is a textbox or other control name on
the calling form.

Hope the helps you. God Bless,

Mark A. Sam