Opening a specific record on new form

[usman4575]

Hi
I have just started learning access and vba for my project. I am creating a database for patient records (my project), I have created a form for 'ptdetails' and i can enter details of patient then i want to create a patient episode/visit so i want to create a button which adds the pt ID automatically from the pt details form and starts a new episode/visit (form). what would be the VBA code for that?
Your help will be much appreciated.

[NeoPa]

Hi Usman. Welcome to Bytes.com.

I don't think you need VBA to handle that. You just need to ensure your tables are designed appropriately (Database Normalisation and Table Structures) and then create a Form (for the Patients) with a SubForm control which has another Form for the Episodes.

[usman4575]

Thanks for your response; i understand that part but i want to enter details of patients in one form like registering customers and then want to add their visit (much like orders) which require more detailed information to be added in the form which is why i wanted to create a registration form for initial or first visit (or search them from the previously registered lists) and then this form calls episodes form and closes itself.

[NeoPa]

What I don't understand at this point is why you believe what I've suggested won't do what you need. It doesn't open a SEPARATE Form, but I don't see why separate is necessary for the first Visit any more than it would be for any subsequent ones.