J
Janet
I have a form where the data source is a table with the
key field of siteID. On the form is a listbox that
displays the siteID and networkID with the bound column=1
or siteID. If I navigate between records, the listbox
changes and everything is fine. If I add a record to the
listbox, the form refreshes and everything works fine.
But, everytime I close the form, I get a parameter query
pop-up box that asks for [forms]![frmSites]![siteID].
The only place I use the reference it is for the
listbox's datasource. (Here's the sql: SELECT
dbo_tblSiteNetworks.siteID, dbo_xTblNetwork.networkMethod
FROM dbo_tblSiteNetworks LEFT JOIN dbo_xTblNetwork ON
dbo_tblSiteNetworks.networkMethodID =
dbo_xTblNetwork.networkID
WHERE dbo_tblSiteNetworks.siteID)=[forms]![frmSites]!
[siteID]"
The knowledge base references an incorrect naming scheme,
but I know that's not applicable since navigating is
working properly between records. I only get the prompt
when I close the form.
Any idea what's causing this? I have listboxes on other
forms and there's no problem.
key field of siteID. On the form is a listbox that
displays the siteID and networkID with the bound column=1
or siteID. If I navigate between records, the listbox
changes and everything is fine. If I add a record to the
listbox, the form refreshes and everything works fine.
But, everytime I close the form, I get a parameter query
pop-up box that asks for [forms]![frmSites]![siteID].
The only place I use the reference it is for the
listbox's datasource. (Here's the sql: SELECT
dbo_tblSiteNetworks.siteID, dbo_xTblNetwork.networkMethod
FROM dbo_tblSiteNetworks LEFT JOIN dbo_xTblNetwork ON
dbo_tblSiteNetworks.networkMethodID =
dbo_xTblNetwork.networkID
WHERE dbo_tblSiteNetworks.siteID)=[forms]![frmSites]!
[siteID]"
The knowledge base references an incorrect naming scheme,
but I know that's not applicable since navigating is
working properly between records. I only get the prompt
when I close the form.
Any idea what's causing this? I have listboxes on other
forms and there's no problem.