Prompt when closing form

B

Bagger

I've got a form that has some nested subforms on it. Everything seems to
work just fine when I'm using the form, but when I close the form, it prompts
me for a value. It looks like the usual prompt you get when you put
bracketed text in a query, which is what I did on the lowest-level subform.
I was trying to use this string as the criteria:

IIf(Not
IsNull([Forms]![frmContractInfo2]![frmInvoiceDO].[Form]![frm_InvoicedetailSubform].[Form]![cmbFundingLink]),[Forms]![frmContractInfo2]![frmInvoiceDO].[Form]![frm_InvoicedetailSubform].[Form]![cmbFundingLink],0)

However, the editor apparently wants to change it to this:

IIf(Not
([tb_invoice_detail].[Mod_Detail_ID])=IsNull([Forms]![frmContractInfo2]![frmInvoiceDO].[Form]![frm_InvoicedetailSubform].[Form]![cmbFundingLink]),[Forms]![frmContractInfo2]![frmInvoiceDO].[Form]![frm_InvoicedetailSubform].[Form]![cmbFundingLink],0)

Now the two look completely different to me, but it seems to be functioning
properly in practice, so I can't really argue with that. The problem comes
when I close the form and it prompts me with the following (titlebar says
"Enter Parameter Value"):

Forms!frmContractInfo2!frmInvoiceDO.Form!frm_InvoicedetailSubform.Form!cmbFundingLink

How can I keep it from prompting me when I close the form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a combobox on another form 3
Sharepoint not capturing staff name when automation runs 0
Dynamic Naming of Form Button 3
Create form with checkbox les that expand and collapse sections of the form? 0
Pop up window?? 5
Help with Form Field 0
Form hides control buttons 0
Update a date field in sub-form from dates fields on main form 1

Top