Group: microsoft.public.access
From: "Dirk Goldgar"
Date: Tuesday, October 16, 2007 7:37 PM
Subject: Re: Form won't work with renamed table...

In news:A487C620-43BC-4EAB-9769-2208CE88E905@microsoft.com,
Deltadog wrote:
> I tried to rename a table I created, but the form that is associated
> with it now displayes a prompting window asking me for a parameter
> value. How can I fix this to where the form will just immediately
> open. Do I have to update some sort of link between the two?

Open the form in design view, open its property sheet, and adjust its
Record Source property (on the Data tab of the property sheet). The
Record Source may be just the table name, in which case you have to
change it, or it may be a SQL statement that you need to edit, or it may
be the name of a stored query. If it's a stored query, you'll need to
edit the query to correct the table name.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


Safety Articles | News in English | 20lbs in 30 days | Bluegrass | Usenet Newsfeeds