Problems with combobox data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top