The data in the subdatasheet was written into a different table. Can you
guess which table it would have been? The column headings will probably give
you a clue. If you open that table, you will find your entry there.
To prevent Access writing orphan records, open the related table in design
view. Select the field that is the foreign key to your main table. In the
lower pane of the table design window, set the field's Required property to
Yes.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Brit said:
i put tougher a database and added a subdata sheet. I inputed some info.
into the the subdatasheet and then saved and exited. When i went back into
the Access again i could not access the info i had inputed into the
subdatasheet. How can i make the computer show me what i imputed.
