How to Rename and keep a link between query and form?

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

Guest

Hi all
How can I rename a file I have in table view that is linked to a file
that I have in form view so that they are the same ......My current form view
filename is "courier contacts" and the file that is linked to it in table
view is called "test".... but when I try to rename "test" ...the "courier
contacts" dont open as it should ....help !!
 
Open your form in design mode, right click on it, left click on properties
and in the Record Source change the name to your renamed table.
 
Unless you are using VBA code to open the table you must have a record source.
Rename the table to what you want it, open the form in design mode and put
the name of the table in record source.
The data tab is completely blank so there is no Record Source
Open your form in design mode, right click on it, left click on properties
and in the Record Source change the name to your renamed table.
Click to expand...
[quoted text clipped - 5 lines]
Click to expand...

--
Never let it be said that I was totally comitted to sanity. It is the dark
places of my mind that fascinate me.

NthDegree

Message posted via AccessMonster.com
 
Thanks for your help .... I just stumbled on the answer by accident .....I
opened the form in design view and noticed in the corner of my fields there
was a little green triangle indicating an error ......when I looked at the
options available I clicked on change properties and the data tab was not
blank this time so I could alter the RecordSource as you advised
earlier....once again thanks for your help ..

NthDegree via AccessMonster.com said:
Unless you are using VBA code to open the table you must have a record source.
Rename the table to what you want it, open the form in design mode and put
the name of the table in record source.
The data tab is completely blank so there is no Record Source
Open your form in design mode, right click on it, left click on properties
and in the Record Source change the name to your renamed table.
Click to expand...
[quoted text clipped - 5 lines]
view is called "test".... but when I try to rename "test" ...the "courier
contacts" dont open as it should ....help !!
Click to expand...
Click to expand...

--
Never let it be said that I was totally comitted to sanity. It is the dark
places of my mind that fascinate me.

NthDegree

Message posted via AccessMonster.com
Click to expand...
 
Back
Top