help, i renamed forms and tables it wont update

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

reservedbcreater - 25 Jan 2005 19:42 GMT

i renamed my tables and forms
now the forms dont update the tables when filled out?
ie the form used to be Water: Sweet Grass
and the table was Water: Sweet Grass

i changed both the form name and table to the same name: Water

yet it doesnt update the table when i fill out the form now?

Reply to this Message

Lynn Trapp - 25 Jan 2005 19:46 GMT

Check to see what the Record Source is for your form

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

>i renamed my tables and forms
> now the forms dont update the tables when filled out?
[quoted text clipped - 4 lines]
>
> yet it doesnt update the table when i fill out the form now?

Reply to this Message

reservedbcreater - 25 Jan 2005 19:54 GMT

where/how do i check that

Reply to this Message

Amit - 25 Jan 2005 20:05 GMT

> where/how do i check that

Open the form in design view, and click on "Properties" in the toolbar. The
first line is "Record Source". Hope this helps.

-Amit

Reply to this Message

reservedbcreater - 25 Jan 2005 19:59 GMT

ok i checked recordsource property
it says Water
the name fo the table is Water
and the name of the form is Water

yet it still wont update will what i fill in the form?

it did until i renamed the forms btw i didnt change anything.

Reply to this Message

John Vinson - 25 Jan 2005 20:04 GMT

>i renamed my tables and forms
>now the forms dont update the tables when filled out?
[quoted text clipped - 4 lines]
>
>yet it doesnt update the table when i fill out the form now?

Open the Form in design view, and view its Properties. Check the first
property on the Data tab, Recordsource. It probably has the old table
name; change it to reflect the new name of the table.

John W. Vinson[MVP]

Reply to this Message