468,557 Members | 2,190 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,557 developers. It's quick & easy.

Opening a specific record on new form

5 Nibble
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.
May 8 '21 #1
3 1804
NeoPa
32,102 Expert Mod 16PB
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.
May 8 '21 #2
usman4575
5 Nibble
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.
May 9 '21 #3
NeoPa
32,102 Expert Mod 16PB
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.
May 9 '21 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by BLUE WATER | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.