Keeping Look Ups in a Make Tabel Query

I need to start a new a new table from a make table query. When I make the new table although I lose all my drop down lists for the user to select information from fields. Is there any way to keep the same previous table format and drop down lists when making this new table?
NuclearOilAsked:
Who is Participating?
 
pcelbaCommented:
Instead of creating new table delete all records from existing table and insert new ones. You may do it as a query:

1) Delete all rows
DELETE FROM YourExistingTable

2) Insert new records
INSERT INTO YourExistingTable (ColumnName1, ColumnName2, ColumnName3, ...)
  VALUES (Value1, Value2, Value3, ...)

or

INSERT INTO YourExistingTable (ColumnName1, ColumnName2, ColumnName3, ...)
  SELECT ColumnX, ColumnY, ColumnZ
    FROM AnotherExistingTable
0
 
NuclearOilAuthor Commented:
That gave me an idea to do it from a macro thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.