appears in table not database view

  • Thread starter Thread starter tina
  • Start date Start date
T

tina

Access 2002
W2000

Records appear in the table and on report but will not
appear in the form view.

Any ideas?

Tina
 
Hello Tina,

I am not sure I understand your statement, but forms, by default appear in
form view, dispalying one record.
You can change to Datasheet view by opening the form in design view and
change the Default View property, shown in the Properties pane.

Ragnar
 
I have a form to write checks. The is a subform is where I
enter the detail and it calulates the check total.
units x price = total amount

We also have the ability to enter units and total amount
(leaving the unit price blank).

The code says that when price loses focus and price is
0.00 then do the calculation.
Click to expand...

This has worked in the past. I made changes in the main
form but did not change the subform. Now I can use the
same procedure and print the check....all is good. But if
I leave the record and then go back into it the subform
has no info. But...the info is still in the table that
makes the subform. It just doesn't appear. And I can re-
print the check with all the info printing correctly.

Why won't it appear in the subform?
 
Access 2002
W2000

Records appear in the table and on report but will not
appear in the form view.
Click to expand...

Perhaps the Form is based on a Query selecting only part of the
records, or you have set a Filter on the form. See if the filter icon
(the funnel) is selected - if so click it to clear the filter.
 
Tina said:
I have a form to write checks. The is a subform is where I
enter the detail and it calulates the check total.
units x price = total amount
Click to expand...

I take it the main form and the subform are based on two different tables,
and the subform is linked to the main form on a pair of form fields, one in
each form?

You can check these link fields by opening the main form in design view and
click on the subform. The property pane will show the Link Child Field and
Link Master Field. Make sure the correct fields are shown.
We also have the ability to enter units and total amount
(leaving the unit price blank).

The code says that when price loses focus and price is

This has worked in the past. I made changes in the main
form but did not change the subform. Now I can use the
same procedure and print the check....all is good. But if
I leave the record and then go back into it the subform
has no info. But...the info is still in the table that
makes the subform. It just doesn't appear. And I can re-
print the check with all the info printing correctly.

Why won't it appear in the subform?
Click to expand...

Without knowing something more about the application it is impossible to
say.
But you could try to create an event proc for the On Record event for the
main form and add a line to requery the subform.

Ragnar
 
Back
Top