macro: copy form

[geekdom jester]

Hi,

i am trying to distribute a blank form_x to be the template for every new customer form.

I created a macro that has these steps:

open form_x
copy form_x
rename copy_form_x to form_y
close form_x
close macro

it does the steps fine. problem is, whenever i update form_y, it also updates form_x and vice versa. how do i unlink them?

HELP!

Thanks,
geekdombum

 

[trucktime]

Form

Just curious to know why you need a new form for every customer,
it's not common practice. Can't you use the same form for very new record?

 

[geekdom jester]

each client is managed separately. each form acts like a spreadsheet that they need to keep and update periodically. combo box values are updated by a query and then account managers have to do some calculations with the values that they selected

 

[trucktime]

Copy forms

Are these forms bound to a table?
In that case the copied form will show the same data, unless you change its data source.

 

[geekdom jester]

is there a way for me to change the record source programatically?

i am not good at syntax. is it something like

dim tablename as string
tablename = "form_y_table"
form_y.recordsource = tablename

thanks

 

[trucktime]

Source

If you follow this practice it would imply that you have a seperate table for each client, that is more or les against the principles of a relational database.

Of course I don't know about your business and what you are trying to accomplish but you may want to re-consider your strategy.
What kind of info are you storing in the database, if it is just numbers and calculations you may be better of using a spreadsheet instead.

In case the database is being used by people who are only supposed to access data of certain clients it may be wise to create a logon system with usernames and passwords and restrict their use.