Problems with combobox data

Hello everybody
Here is my question and i hope that somebady can help me.
I have the maintenance of a number of blocks of flats that change financial
administrators every 6 months or each year.
I had made a database to keep data for these buildings and their
administrators and i want to use it in order to give simple receipts.
I have a form that enter the building's data with a subform in which i enter
all administrators for these building
I have another form in order to enter receipt's data. In this form i want
for a specific building to choose each time a different administrator using a
combobox.
My question is:
How can i make in this combo box to be appeared only the names of the
administrators for the specific bulding only.
In the properties of the combox box i specify where to find the data and now
in the box appeared all the administrators of all bulidings. I understand
that i had to use some criteria somewhere but i don't know where.
Can anbody help me?

Thank you in advance

http://www.mvps.org/access/forms/frm0028.htm

HTH;

Amy

"thalis" wrote in message
...
Hello everybody
Here is my question and i hope that somebady can help me.
I have the maintenance of a number of blocks of flats that change
financial
administrators every 6 months or each year.
I had made a database to keep data for these buildings and their
administrators and i want to use it in order to give simple receipts.
I have a form that enter the building's data with a subform in which i
enter
all administrators for these building
I have another form in order to enter receipt's data. In this form i want
for a specific building to choose each time a different administrator
using a
combobox.
My question is:
How can i make in this combo box to be appeared only the names of the
administrators for the specific bulding only.
In the properties of the combox box i specify where to find the data and
now
in the box appeared all the administrators of all bulidings. I understand
that i had to use some criteria somewhere but i don't know where.
Can anbody help me?

Thank you in advance

I will try to solve my problem with the following advice but in my case i
want to limit the contents of the combo box based on the value of a simple
field in the form. For example i enter the ID of the buliding, automatically
all buildings data entered, then i enter the date etc and i want in the combo
box to have the administrators only for this building.

"Amy Blankenship" wrote:

http://www.mvps.org/access/forms/frm0028.htm

HTH;

Amy

"thalis" wrote in message
...
Hello everybody
Here is my question and i hope that somebady can help me.
I have the maintenance of a number of blocks of flats that change
financial
administrators every 6 months or each year.
I had made a database to keep data for these buildings and their
administrators and i want to use it in order to give simple receipts.
I have a form that enter the building's data with a subform in which i
enter
all administrators for these building
I have another form in order to enter receipt's data. In this form i want
for a specific building to choose each time a different administrator
using a
combobox.
My question is:
How can i make in this combo box to be appeared only the names of the
administrators for the specific bulding only.
In the properties of the combox box i specify where to find the data and
now
in the box appeared all the administrators of all bulidings. I understand
that i had to use some criteria somewhere but i don't know where.
Can anbody help me?

Thank you in advance