Calling up Modal Form from Continuous Form (A2K)

Topic

New Reply

Ya gotta love Access! The following code calls up my modal form from within a single form with no problem.

Private Sub txtF06_Click()
On Error GoTo Err_txtF06_Click
DoCmd.OpenForm “frm Corporations – Contacts”, windowmode:=acDialog, wherecondition:=”AGMSysKey=” & cboVendor
Exit_txtF06_Click:
Exit Sub
Err_txtF06_Click:
MsgBox Err.Description
Resume Exit_txtF06_Click
End Sub

However, when I try to run the same thing after I

Reply | Quote

Replies

Hi Andy,
Where are txtF06 and cboVendor located on the form?
What is the error message?
Remember that for a continuous form, if the controls are in the details section (not header or footer) then there is only one instance of the controls, just reiterated for as many records as there are.

gdr

Reply | Quote

Gary,

As they say in the Real Estate world, “Location, Location, Location”. Once I moved my control button up into the header instead of on the detail line, all worked well. Thanks kindly for your help,

Reply | Quote

I don’t believe that windowmode:=acDialog is compatible with a continuous form – though I’m not positive, and a quick scan of Help doesn’t give any hints. Try setting the Modal and PopUp properties and Continuous and see if Access complains. Also, what error message do you get when the code crashes?

Reply | Quote

Hi Wendell,

As you can tell by my comments to Gary, all is well. Thanks kindly for jumping in,

Reply | Quote