If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Not recorded unless tab opened
I created a form with four tabs and (registration, progress,delivery of baby,
and after delivery care. When i creat a new patient record in registration by putting name some details in the registration tab, if i close it at that point, the record cannot be recovered back into the form. However its in the table when i look for it. The surprising issue is if i open the delivery of baby tab and i only put in one single information, then i can recover that information on the form . The patient record will only be recovered if i fill the delivery of baby tab and no other tab allows this. This is a problem. I should be able to open the registration tab, fill in a few criterias and close it. Then decide to reopen and continue to fill out more information on the patient as things progress. But it will not occur unless i also open the delivery of baby tab, put in a small information . What hav i done wrong?? |
#2
|
|||
|
|||
Not recorded unless tab opened
I may be wrong about this but it sounds to me as if the forms are not linked
in the right way or it may worse than that and the tables may not be linked correctley. MAKE A BACK UP YOUR DATABASE and work on the copy (just in case) You have at the moment 1 form with 4 tabbed forms ? What is on the main form ? Try this. Create a form from the table containg details of the baby (name, DoB, etc) Ensure that each record (baby) has a unique number (ID) In this form add the details that are specific to that baby. Next add the 3 other linked form as subforms (you can place them on tabs if you want). Ensure that each sub form is linked to the main baby form by the ID. If you still have problems you could post back with more details of the tables, links, sql (if you have any), etc. -- Wayne Manchester, England. "reportyemi" wrote: I created a form with four tabs and (registration, progress,delivery of baby, and after delivery care. When i creat a new patient record in registration by putting name some details in the registration tab, if i close it at that point, the record cannot be recovered back into the form. However its in the table when i look for it. The surprising issue is if i open the delivery of baby tab and i only put in one single information, then i can recover that information on the form . The patient record will only be recovered if i fill the delivery of baby tab and no other tab allows this. This is a problem. I should be able to open the registration tab, fill in a few criterias and close it. Then decide to reopen and continue to fill out more information on the patient as things progress. But it will not occur unless i also open the delivery of baby tab, put in a small information . What hav i done wrong?? |
#3
|
|||
|
|||
Not recorded unless tab opened
On Wed, 28 Apr 2010 23:54:01 -0700, reportyemi
wrote: I created a form with four tabs and (registration, progress,delivery of baby, and after delivery care. When i creat a new patient record in registration by putting name some details in the registration tab, if i close it at that point, the record cannot be recovered back into the form. However its in the table when i look for it. The surprising issue is if i open the delivery of baby tab and i only put in one single information, then i can recover that information on the form . The patient record will only be recovered if i fill the delivery of baby tab and no other tab allows this. This is a problem. I should be able to open the registration tab, fill in a few criterias and close it. Then decide to reopen and continue to fill out more information on the patient as things progress. But it will not occur unless i also open the delivery of baby tab, put in a small information . What hav i done wrong?? The tabs are *completely irrelevant* functionally: a tab is just a way to arrange screen space. It appears that you have based the main form on a query joining the registration table to the delivery table; if it's the default INNER JOIN query, you'll need data in both tables to see either table on the form. What is the main form's Recordsource property? Post the SQL if it's a query. Does the delivery tab have a Subform control on it? If so what's its Recordsource. The typical design would be a mainform based on the Registration table with four Subforms (which can certainly be on different tab pages, though the form will work the same whether they are or aren't), each bound to one of the four related tables, using the patient ID as the master/child link field. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|