I think I need a button that when selected would duplicate certain fields on a form

[LadyLyke]

I have a form created titled Days of Service for our clients which calculates their entry date and their ending dates of services. On the same form I have 3 fields that calculate if the resident leaves to go to the hospital. Both of these work great my problem is that some of our residents may leave to the hospital and come back multiple times. I don't want to put multiple hospital stays fields on the form since not all the residents even leave for the hospital.

What I would like to create is either an option button or a button that when selected would paste the hospital stay again below the original. On the Days of Service table I have created hospital entry, exit and total 1-4 respectively. What I can't figure out is how to accomplish what I need. Is there a way to add the fields but make them invisible unless the button is selected?

[Subwind]

Would you not be better off having a seperate table for the visits, this way patients can have as many as needed, rather than a specified amount?

~Matt

[LadyLyke]

So you think the better option would be to create multiple tables or create a button that makes a table with specified columns? I'm new to Access and I'm learning as I go along so I'm still trying to figure out what Access can and cannot do.

[Subwind]

So you think the better option would be to create multiple tables or create a button that makes a table with specified columns? I'm new to Access and I'm learning as I go along so I'm still trying to figure out what Access can and cannot do.

This would be the best option, that way each of your patients can have as many, or as few, in and outs as they like. PM me if you want some help.

~Matt