Run table make query after form input

[ACCESS NEWB]

Hi
How can I make table make query run when i click on add new record in my form,or when i exit form?

 

[CyberLynx]

What type of Query and why?

.

 

[ACCESS NEWB]

Why is very good question. I realize I can not get what I want in this way,simply because running table make query overwrite exisiting table which means that new created table cannot be in relationship with others,
so lets forget I asked anything in a first place

Thank you for your reply though

 

[namliam]

You will want to run an Append query and use the "on exit" event of the form

 

[gemma-the-husky]

Why is very good question. I realize I can not get what I want in this way,simply because running table make query overwrite exisiting table which means that new created table cannot be in relationship with others,
so lets forget I asked anything in a first place

i dont think this is correct - i think if the new table has the same columns and same name, the realtionships will stay in place

YOU WILL lose any indexes with a new table, so instead of a maketable you could always

1) delete data in existing table (delete * from table)
2) append all the new data (insert into table) - again, it assumes the fields are all named the same

 

[Rabbie]

i dont think this is correct - i think if the new table has the same columns and same name, the realtionships will stay in place

YOU WILL lose any indexes with a new table, so instead of a maketable you could always

1) delete data in existing table (delete * from table)
2) append all the new data (insert into table) - again, it assumes the fields are all named the same

Gemma has hit the nail on the head. If you delete the old data and insert the
new data you will keep the relationships and the indexes. definitely the best way to go. As a bonus it is also quicker.