Forms - Automaticaly moving data to another table if part of a certain category

Hello Everyone,

Is there a way that when someone enters data into a form, if the person who they are entering is part of a certain group then it is automaticaly transfered to a different table and then deleted from the table they were originaly entered in?

Thank you!

This would not be a good way about going about the problem...

I'm guessing that you have a table and want separate (identical) tables for each group? If this is the case leave all the data in a single table and have a field within this table showing the group the person is a member of.

You can then easily report on a given group using queries and/or reports. Trust me this will make your life a lot easier in the long run…

If I’ve misread your problem or any other queries please let me know!

Hey,

I have a form that goes into a table of sales. There are two tables in total. One is sales for individuals and one is for companies. Sometimes I get individulas that really should be entered into the company table. So what I want is if the individual is ented into the individuals form....i need that moved to the company form....is that posible.

It's confusing to describe.

Again I think you would be better off with only one table and a field, maybe a tickbox, for company/individual.

If this is going to be impractical then the way I would move the record would be to execute an append query then a delete query from a button on you form. The syntax for the append and delete query would be along the following lines, depending on table and field names you are using:





Although you would definitely be better off with only one table, it will make things so much easier, especially when reporting, for example when you want overall sales reports showing company and individuals sales combined…