Show data in textbox

[razzel]

Hi everybody and Merry Christmas!



I have an Access table with several columns and corresponding field names. The purpose of the db is to keep track of ipads, macs and pcs on some schools.

One of the fields is named "Departments". Now, every School is divided into different departments based on the age of the students, like this:

School A
Department1
Department2
Department3

On School A Department2 got 10 ipads, so in the table each one is registrered by serialnumber. And since Department2 have 10 iapads, there will be 10 rows in the table that reflect this fact.

I have created a form and on the form I have put a textbox. To fetch the information about the 10 ipads (I just want to put the number 10 into the textbox), I use this string:

=abs(Summa([IPads]![Building]="Department2"))

The strange thing is that it will work until a restart Access. If I close down Access and restart it, the form will not show me the number 10, instead it will say #Error.

Anybody that can spread some light on this?

I am using Access 2013, Windows 8.1

[June7]

What is Summa() - is that a custom function?

Is Building field in the form RecordSource?

Is the textbox in form Footer section?

Try: =Sum(IIf([Building]="Department2",1,0))

[razzel]

[QUOTE=June7;258103]What is Summa() - is that a custom function? YES, summa is sum on Swedish (I am using the Swedish version of Access 2013)

Is Building field in the form RecordSource? What exactly is the "RecordSource"?

Is the textbox in form Footer section? YES

I did make another test and put this in the Controlbox:

=Antal([Serienummer])

Antal = Count

It works perfectly until I close Access and open Access again. Then the
textbox shows #Error.

[June7]

Then Summa is intrinsic function, not custom.

The RecordSource is property of form. It binds the form to data (table or query).

No idea why the expressions errors. The syntax looks good. If you want to provide db for analysis, follow instructions at bottom of my post. Don't know what will happen when I open the db but will try to review it anyway.

[razzel]

Then Summa is intrinsic function, not custom.

The RecordSource is property of form. It binds the form to data (table or query).

No idea why the expressions errors. The syntax looks good. If you want to provide db for analysis, follow instructions at bottom of my post. Don't know what will happen when I open the db but will try to review it anyway.

I thrashed the entire db and recreated it form scratch and now everything is working just fine. :-)

I have a short follow-up quesation: can I create a button and have it open a question? If so, I would put the button directly into the form.

[June7]

What do you mean by 'open a question' - open a form that displays a record? Yes.