Form won't work with renamed table...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Rename" function not working right 4
How do you rename a table? 3
Renaming control 2
DB2 linked tables have underscore in column names. 0
how to rename a table using field name 1
Rename Multiple Tables at once 3
Access Form Refresh 1
Rename Linked Table (If Needed) 6

Back
Top