Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

auujxa2 - 26 Mar 2008 14:08 GMT

I'll do my best to explain what I want to accomplish, and perhaps someone can
point me in the right direction.

I'd like to create a form, where the user can select records from one box (i.
e. Active Stores), and click a button to drag them over to another box (i.e.
Inactive Stores).

Like when you use form wizard where you select the table/query and the
available/selected fields.

Any direction would be greatly appreciated.

Thank You in advance.

Reply to this Message

Jerry Whittle - 26 Mar 2008 17:18 GMT

If you are talking about moving records from an Active table to an Inactive
table using a form, that would be a very bad idea. You would be much better
off adding a Yes/No field called Inactive to your "Active" table. Change this
field to Yes when the record is inactive. Base all your query criteria on
this field depending if you want to see Active or Inactive records.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I'll do my best to explain what I want to accomplish, and perhaps someone can
> point me in the right direction.
[quoted text clipped - 9 lines]
>
> Thank You in advance.

Reply to this Message