I found it, just poking around due to desperation. It was part of a query behind a combo box.
Thanks for the tip.
Bill
Minnesota
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, January 12, 2016 1:58 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Can't find the parameter
Bill-
Try opening the form in Design view, changing the Record Source to something else (doesn't matter what), then changing it back. That will refresh the form field properties.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 12, 2016, at 8:39 PM, 'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have Access 2013 database that tracks customers and creates invoices. The person I am designing this database for wants the State information in the address to be a combo box. So I have been converting the forms. Now I have a problem. When I open one of my forms I get a box that asks for the parameter for t_Organizations.orgSt . This is the old State field prior to converting it to a combo box.
In the table t_organizations I have deleted the field called orgSt.
In the query for the form there is no such field.
I can't figure out where the form is calling for t_Organizations.orgSt
Is there any way to do a database search for an item like this?
Thanks for all your help.
Bill
Minnesota -13 degrees this moring.
Posted by: "Bill Singer" <Bill.Singer@at-group.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar