RECORDS IN FORMS

[CRAIG]

I have a database with a couple of forms, each form has
about 10 fields which are common to all the forms, I have
set the relationships between the forms and this appears
to work.

I need to set the forms so that if I am looking at record
10 on form 'A' then open Form 'B' record 10 is also
displayed, at the moment each time I navigate between
forms I go back to record Number 1.

Anyone have any ideas?

Thanks

Craig.

 

[Andre T.]

I believe the reason they go back to record number 1 is because the queries
each form based are separate which pulls the whole table over (or something
like that)

One way I solve this situation is to make one form dependent on the other,
and I set one query based on the control field of the other.

Another way I solve this situation is when I open the 2nd form, I
"FindRecord" to the record on the other form.

If there are several forms and either form can lead the navigation, you may
want to create a hidden form (visible=false) to keep the current location
whenever you open a form, and find record using the current location of the
hidden form.

Hope this helps.

Andre T.