Command Button to open form

[acss]

I am trying to open a form through a command button placed on master form. Is
this done event procedure and is it possable to hide the master when the
second is viewed then return when closing the secondary form?

 

[acss]

That works fine and if i may impose on one more thing in that the second form
always resets to the first record while the master maintains the record from
which the command button is activated. Is there some way for the second form
to launch and not resetting to record 1?

Thanks

 

[acss]

Actually, the second form is a copy of the first but represents data entry
for a different country so while the main form may be at record 50 the second
form may be at 21 or 22..etc. It would be easier if the second form just
opened up from the last entry that was done on that form. Can this be done?

Yes,

There is a parameter in the OpenForm method for passing it a criteria; it is
the last parameter before the acDialog. What I generally do is declare a
criteria string variable, then I define that just before the OpenForm method

Private Sub cmd_OpenForm

Dim strCriteria as string

strCriteria = "[ID] = " & me.txt_ID
me.visible = false
docmd.OpenForm "formName",,,,strCriteria,acDialog
me.visible = true

End Sub

This assumes you have a numeric ID field associated with the first form and
it is displayed in a control (txt_ID). It also assumes that the form you are
opening has an identical field.

When you use this technique, the new form that is opened will open to the
record corresponding to the current record in your main form.

HTH
Dale

That works fine and if i may impose on one more thing in that the second form
always resets to the first record while the master maintains the record from
which the command button is activated. Is there some way for the second form
to launch and not resetting to record 1?

Thanks

Sure, you would use the command buttons Click event, something like:

[quoted text clipped - 18 lines]

this done event procedure and is it possable to hide the master when the
second is viewed then return when closing the secondary form?

--
HTH

Dale Fye

Message posted via AccessMonster.com