retrieving records from table

[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).

 

[Guest]

Hi

It sounds to me as if your form is set to Data Entry.

Open the form in design view - open the form's property box and in the Data
column select DataEntry = No

Hope this helps