Access form with many subforms in it

[Dasun]

Hey guys,

I have a little bit of knowledge about Access. I learnt everything by myself from practice and I have no exact idea of how tables are mapped in relations and other tables connecting stuff even though I tried hard to understand.

I have an Access form bound to two fields called ID number and Received Date.

those are the main two fields I need to manage this Patient Management System.

And this form contains another 10 subforms which used to store laboratory test results and other procedure and details of the patient.

But all of these tables are connected using either ID or Received Date of the Patient where each record of every table must be able to identify each record uniquely using those two main keys of the patient.....

The 10 subforms are bound to 10 separate tables where I want each of these subforms should be arranged in one main form for data entry.

I have several questions

1) I set the link child and master fields to ID in each subform. And I want to put a save record button at the end of the main subform.so when I'm done entering data into every subform and when save button is clicked(which is in the main form) all data should be saved in tables. But at the moment, when I click the save button it does not work that way

2) It is a huge waste of time to keep entering ID number to each of 10 subforms. I need to know if I can find a way for the ID number to be automatically displayed in every text box in each subform where ID text box is located.


My heartfelt Gratitude will be gone to all the supporters.
love you all

 

[Trevor G]

Welcome to the forum,

Have you set up relationships from the main table to each additional table, if so when you select a record in the main form, all subforms should use the same ID field, so there should be no need to type any ID field in.

I would be curious to see a sample of the database, would that be possible, can you create a copy of the database, strip out the main data and upload a version of the database in Access 2003 format (as this is the preferred version for the Forum). Give a brief note of the main table name and subtables, and the main form you are using.

Uploaded database's can't be more than 2mg so you might need to zip it first.

I would be happy to take a look and see how we can help you.

 

[Dasun]

please tell me how to uload it. I tried uloading it to media fire. and

the foum only gives permission to post a link in the reply space only we have more than 10 posts

cmonnnnn

 

[Dasun]

sorry guys did nt see the attachment thngee here....

the text file uploadd will have the link to the media fire download page


ma accdb file is 12Mbs

 

[Trevor G]

You have no data in any of the tables that are related to the BaseLine1 table. So the ID field can't show anything.

On your search form, non of the subforms can be related to the BaseLine Table as the search form isn't connect to a source.

I would create your Search form based on the BaseLine1 table then you can set your relationships to each of the subforms.

You don't need to show any data in the form but do need to have the ID test field in it otherwise you can't set Master and Child links.

 

[Dasun]

Tnx for the Help. Trevor G.

Actually the form that Im struggling with is the "Data Entry" form. I need to enter data to the tables using that form. Search form is all good though, as you said when the record source is set.

I understand what you said. However pls do as you mentioned so I could learn what you have done.


Thank you very very much

 

[Trevor G]

Open up the table Baseline1 then use the Create Tab and select form you will get a form and it will show you the record you left in the database, as the field has masking then you need that mask as well.

Then do the same with the other tables, so you end up with a couple of forms. Then in the main form you have created for Baseline1 open the form in design view then drag the other forms from the navigation windon ito it, that should then generate the Link Subform feature and you can then tidy everything up once it is working.

I hope this helps you.

 

[Dasun]

tnx heaps my good friend Trevor G.

I just realized how to do it.

Tnx a lot for helping me. Pls tell me anything if u have

I know PHP, ASP.net and C# and JQuery for some good extent

Ill help you in anything if u want

 

[Dasun]

and another problem is still there.. Do you know how to display the ID field in each table without using a Macro, by just using only the VB code