Selasa, 12 Januari 2016

Re: [MS_AccessPros] Can't find the parameter



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' [MS_Access_Professionals] <> 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.
Minnesota   -13 degrees this moring.  


Posted by: John Viescas <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)



Tidak ada komentar:

Posting Komentar