auto fill data from a table

N

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

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
 
N

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

Golfinray said:
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 said:
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top