Form Question

[Ken_C]

Is there a way to append a specific record entered into a form to a serpate table based on a form entry?

ex. When a user types the word "true" add the record to tblTrue, but if the user enters the word "false" add the record to tblFalse.

I'm tryin to do this because the company I work for has specific customer codes that they can and can't handle. It would make it alot easier for the admin if she had two seperate tables of records, one that she can work in and one that she needs to send to a contractor company.

Is this possible?

 

[ansentry]

You do not have to have 2 tables, you can use 1 table and have a field for "True" or "False".

Have a look at my attached sample.Have a look at the queries you will see how you can filter the records for forms or reports.

 

[Ken_C]

Thanks! you guys are amazing. I didn't think of setting it up like that.

 

[ansentry]

Glad to help.