Records irretrievable from tables

[Guest]

I have a quoation table that is linked to a quoation details table. I then
have a form with a quoation table main form and quation details subform. This
subform contains three fields, all of which are controlled by the RTF2
ActiveX control so that words can be individually formatted. The subform is
linked to the main form by the Quotation No.

Once I enter data into the form, subform, or both it essentially disappears.
If I click my print preview button, the report is blank. If I close the form
and reopen it, it goes to a new record pretending like the old record never
existed. After I enter that new record, I cannot advance to another new
record. Although all this occurs, the data is correctly entered in both
tables. I cannot view the records through either the form or the report. The
report is setup via a query to retrieve data from an employees table and the
two quotation tables. When I click on that query, it also retrieves no data
even though there is data in all three tables.

I am at a complete loss as to why this is occurring and can only guess that
it has something to do with the rtf control (which is necessary for the form
to function in the required manner).

 

[John Vinson]

Once I enter data into the form, subform, or both it essentially disappears.
If I click my print preview button, the report is blank. If I close the form
and reopen it, it goes to a new record pretending like the old record never
existed. After I enter that new record, I cannot advance to another new
record. Although all this occurs, the data is correctly entered in both
tables. I cannot view the records through either the form or the report. The
report is setup via a query to retrieve data from an employees table and the
two quotation tables. When I click on that query, it also retrieves no data
even though there is data in all three tables.

Perhaps you could post the SQL of the query. Are you CERTAIN that the
joins are correct, and that there is matching data in the joining
fields in all three tables? The symptom certainly sounds like the data
is in the tables, but the join (or the data in the join fields) is
incorrect!

John W. Vinson[MVP]