auto fill data from a table

[nyyanx18]

I am trying to create a database for violations of inspected facilities. I
have a list of the names of the facilities and addresses. I want to create a
form for each violation (there are several at each facility) for data
entry--select facility name from a drop down. How can I get the address of
that facility (as well as other information contained in that table) to
automatically display when I select that facility.
For example:
A violation has been detected at building A. I need to enter the data about
this violation. I want to select "Building A" from a drop down, and then
below it, the address, etc. is automatically displayed. In another box, i
type in the information...

 

[Golfinray]

Put a combo box on your from. Let the wizard do it for you and select
building name as the field. Then right click on the combo to get to
properties, click on events, then afterupdate. Go out to the right and click
on the little button. Choose code builder and type:
Me.filter = "[buildingname] = """ & me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo10 or combo2

 

[nyyanx18]

I tried this and it did not work. I forgot to mention that I am new to
access and only have figured out the basics. Let me try to explain a little
better what i need. I have a table- 1 column has building name, another
column has address. I made a query of these two. I want to select building
name from a drop down and have the corresponding address show up below it.


Thanks

Put a combo box on your from. Let the wizard do it for you and select
building name as the field. Then right click on the combo to get to
properties, click on events, then afterupdate. Go out to the right and click
on the little button. Choose code builder and type:
Me.filter = "[buildingname] = """ & me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo10 or combo2

I am trying to create a database for violations of inspected facilities. I
have a list of the names of the facilities and addresses. I want to create a
form for each violation (there are several at each facility) for data
entry--select facility name from a drop down. How can I get the address of
that facility (as well as other information contained in that table) to
automatically display when I select that facility.
For example:
A violation has been detected at building A. I need to enter the data about
this violation. I want to select "Building A" from a drop down, and then
below it, the address, etc. is automatically displayed. In another box, i
type in the information...