moving records between forms

[joeyg]

OK guys. Thanks in advance to anyone who can help with this issue. I am a newbie to the access world so bear with me. I am trying to design patient lists for use in a hospital setting. I would like to create 3 basic forms (or patient lists) and be able to move a patient (or record) between these forms. I have successfully created the forms and associated table. My initial thoughts were to put a control button on the form which would activate a macro to "cut" the record from one form and "paste" it to another. However, I have not been able to do that. I have tried multiple different ways, all unsuccessful. I guess my first question is, should these forms be in the same database or different datatbases, or does it not matter? Seocnd, is this the right approach to my problem? If so, can someone help with the macro actions? Maybe I just haven't designed the right macro yet. People have suggested changing the status of a record but that means that I would have to sort through all the records all the time. That would be very cumbersome with time. I am desingning this for a department and I need to make this as simple as possible. Thanks again.
Joe

 

[Parker]

Forms are used for imputing or displaying data not for storing it. Tables are used for storing data.

If you already have the information, you do not need to "cut" it from one form and "paste" it to another. You just need to refer the controls on your second form to the, already, stored data.

A better explanation of what you are trying to achieve may help.

 

[missinglinq]

One table/one database is the way to go here. A technique I've used for a similar purpose (distinguishing active patients from inactive patients) is to use a check box (if checked patient is inactive). Then the query for, say the active patient form looks to see if each record is "tagged" as active or inactive. This concept could be extended to cover three cases, as you stated, by using three option butons and having the appropriate query check the status of each. I believe the option buttons allow you to have only one of the three selected.

Whether to use one form or three really depends on exactly what data is shown on each. The advice about staying away from macros is right on target for a bunch of reasons. Very few "heavy" Access users utilize macros.

Hope this helps.

The Missinglinq

 

[joeyg]

Thanks alot everyone. I'll work on that and let you know how it went.
Joe