Not recorded unless tab opened

[reportyemi]

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??

 

[Wayne-I-M]

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.

 

[John W. Vinson]

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.