Changing table

[ksimmsa]

I have a form created, but I need to change the table the data is stored in.

Thanks in advance for your help.

 

[PHV]

Have you tried to change the RecordSource property of the form ?
Check carefully all the ControlSource properties of the bound and calculated controls.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[willir]

PHV is correct.

Before we start, you may want to copy the table in question.

To change the ControlSource, open the form in design mode. Make sure the Properties window is open (from the menu, "View" -> "Properties")

Now select the form by click on the square box in the top left corner where the horizontal ruler meets the vertical ruler.

Then select the "Data" tab in the Properties window. The control source will reference a table or a query. You can change the ControlSource.

...Be warned. If the names of the fields in the new ControlSource differ between the old and new source, the controls (text boxes, combo boxes, etc) on the form will not recognize the new source and will display an error when the form is opened.

Richard