472,958 Members | 2,514 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 software developers and data experts.

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 2183
NeoPa
32,547 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,547 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

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

Similar topics

9
by: BLUE WATER | last post by:
Help, When I am finished entering in data into my form A, I press the save button that saves this new data to a new record. However I would like my other form to open at a specific record, the...
1
by: Ian | last post by:
I want to open a form at a particular record, but I think I'm running into problems because the recordsource query is executing asynchronously. In the form's open event I use...
3
by: cmp80 | last post by:
I have a database that I am using to store student data. There are two tables and two forms to display the data: Tables tbStudent tbRE Forms fmStudent fmRE
2
by: rousseaud | last post by:
I have a continuous form, frmA, that lists certain record fields from tblB. I want to be able to click on one of the records in frmA (just an on click event on one of the form fields) and have that...
10
by: sara | last post by:
Hi - I have been struggling with solution ideas for this now for almost 2 weeks, and have not been able to figure this out. I have a user who creates a Purchase Order (tblPOData). In some...
1
by: Martin Bentler | last post by:
Right now, I have a form, locked records, on which I have a CommandButton that opens a second form (much like the first) but open for editing, plus allowing the user to manipulate other areas of the...
2
by: wisni1rr | last post by:
I have a form where my user can enter in basic information. I have a button the user presses to save the record, close the form, and open up another form to the most recent record where the user can...
9
by: farooqkhan123 | last post by:
Hi I have a subform that displays a query result. I want to be able to click on any record on that subform and that opens up that specific record in a form called PUN Prefill. I am not a developer...
6
by: Zork182 | last post by:
Hi, I have an access database and created two forms. The first form looks up Assets by inventory number and shows the student the assets are assigned to. The second form shows the student and...
6
by: JPetersen | last post by:
I have a subform of all the customers for the day (limited info). I want to open the specific record on the parent form by clicking an action button, on a specific record, on the subform. I have...
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.