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

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" wrote:

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

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

"Golfinray" wrote:

> 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" wrote:
>
> > 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...