Forms

  • Thread starter Thread starter kena
  • Start date Start date
K

kena

I have created a form and set up tabs to input different
segments of data. I have reached the point now where I
want to have more tabs than the form will allow, so I
created another form. When I open the new form I want the
data to be from the same record. Also when I return to
the origional form I want the same record.
I am not sure whether I should use a sub form or a series
of additional forms.
Also I don't know how to "synchronise" the forms to
always display and save the current record I started with
on the origional form.
Hope I have explained my problem clearly and would
appreciate any assistance or pointing in the right
direction.
 
Kena,

Simply a button on each form the uses the OpenForm method with the WHERE
parameter:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "YourForm"

stLinkCriteria = "[PrimaryKey]=" & Me![CurrentFormControlWithPrimaryKey]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Hope that helps.
Sprinks
 
Back
Top