Dup Table, use same form

[Cindy]

Hi everyone.

I have two tables, and one form (very simple database)

tbDefault
tblContacts
frmInfo

1st) What I need to do is use frmInfo to have a drop down
box that shows my tables with the default tblXXXXX and not
show tbXXXXX.

2nd) The tables listed when selected use the form frmInfo

3rd) In the drop down box have a "Add New Table". This
would take the table tbDefault and copy it and ask for a
name for the new table (and provide an example, i.e. use
this format, tblXXXXX and would not alow to save the table
with any different format), then add that to the drop down
box and open the new table on the form frmInfo.

Is this possible and is there an example, or can someone
offer any help with this?

Thank you so much, Cindy

 

[Cindy]

deeply suspicious?

This is what I was asked to do. I suggested using a query,
but the reply was, that this is not how they wish to do
it. Part of their reason, is that it would simplify
archiving and they have other forms that would only allow
certain users to have access to certain data, simply. They
do not what to use the built in security as they have had
problems in the past and the recovery of their data was
very exspensive. So they have taken a different approach.

Can this be done without a lot of trouble?

Thank you for your response


Cindy

-----Original Message-----

 

[Cindy]

Thank you for your reply.

I will repost. I need further help with this.

Thank you again

Cindy

-----Original Message-----