If the data is in the table but not in the form, you may have a filter on
the form. If the form is based on a query, then, when you look at the
query, in data view, do you see the records? if not, then, probably, you
have a criteria in the query that filter out those records. Remove the
criteria if that is the case.

Sure, the easier way is to edit the data in the table, add the required data
in the field (so you will be able to see the records in the form), but that
won't avoid the problem to re-occur. You can always design the table to NOT
ALLOW NULL under your field , if that makes sense. But knot having all the
details, I strongly suspect you used a filter or a criteria which eliminates
the records. A little bit if you have a criteria under a quantity field that
said: 10 then only records having their quantity value 10 would be
picked up.

So start with the query. Is your records are available there? if not, remove
the criteria which makes no sense.
If the data is there, then open the form, and remove the form filter, if
there is one.



Vanderghast, Access MVP.


"Yula" wrote in message
...
Michael, Thank you, but I am still lost. I substituted your first formula
into my nish field and I am getting a calculation. The problem is that I
want
to see all the data that I entered into the database. I am missing 7
records
because they did not require me to enter anything into the Length/Width
fields. I see all that data in the tables, bit not in the form/query. Is
it
possible to fix? or should I erase them from my tables and reenter those
records?
"Michel Walsh" wrote:

If there is no finish rate defined, what would be the result?

You can use:

=Nz( [Finish Rate] * [Copies Requested] * iif( [Finish Square Foot]="X",
[Sq
Ft], 1), "undefined" )


which will display "undefined" (without quote) if any of the three
fields
is not defined.


You could also have use a Format to format the NULL values as displaying
"undefined" instead of the blank you should see at the moment when a null
is
involved in the computation.




Vanderghast, Access MVP



"Yula" wrote in message
news
I have a combo box in a form (Based on a query) that looks up values in
the
Finish Lookup table. The table has the following info:
Finish Description Finish Rate Finish Sq Ft
Coil .45
Cutting 0
Foam 3.50 X
Folded 0
Lamintated .218 X

The next text box has
length
Width

To get the finish cost I have the following formula:
=IIf([Finish Square Foot]="X",[Finish Rate]*[Sq Ft]*[Copies
Requested],[Finish Rate]*[Copies Requested])

After I add new records, I only see the records where I choice a finish
description that has a finish rate associated with it, I do not see all
records with the zeros for the finish rate. What confuses me is that I
see
all the tables being populated with all the info that I enter (0 rate
descriptions and actual rate descriptions)

I have to present all this info today and I have no clue why the query
is
only showing those records with the rates associated with them. I don't
have
any criterias set up.

Thanks so much,
Yula