Form won't work with renamed table...

D

Deltadog

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?
 
D

Dirk Goldgar

In
Deltadog said:
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?
Click to expand...

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.
 
Top