Expression

  • Thread starter Thread starter Alicia
  • Start date Start date
A

Alicia

I have a box on my form containing a starting stock value
("total new"). I want to add this number to the new stock
quantity from my previous table ("Yellow"). I have used
the following expression in a new text box named total
stock:

=[total new]+[forms]![frmmachineryin]![Yellow]

but the box is coming up with #name? on my form. Any clues?

(Help (Access2000) says this is happening because I am
missing a file msowcf.dll but I have searched and have
this file.)
 
I have a box on my form containing a starting stock value
("total new"). I want to add this number to the new stock
quantity from my previous table ("Yellow").
Click to expand...

What do you mean by "my previous table"? is the TABLE named [Yellow]?
I have used
the following expression in a new text box named total
stock:

=[total new]+[forms]![frmmachineryin]![Yellow]
Click to expand...

This will look on a Form named [frmachineryin] for a Textbox or other
control named [Yellow] and retrieve whatever value is found in the
current record on that Form - *if* the Form is open.

Note that a form IS NOT A TABLE - if you're trying to get data from a
table, DLookUp will be a better bet than using a Form.
 
Back
Top