Articles

fill in field automatically based on other 1

May 19, 2009 at 10:10:58
Specs: Windows XP

I'm trying to figure out how to get Access 2007 to fill in one field based on what is put in another field. Specifically, I want a Region field to fill in automatically based on what is put in the County field. I have a table that lists the counties in one field and their region in another field. I have another table that lists organizations and the organizations data. Two of the fields I want included are the county and region, and I want the County field to be a drop-down box pulling from the other table that lists the counties and regions. I want the Region field in the organizations table to automatically fill in the region corresponding to the county once the county is selected.

Is there a way to do that? Do I need to set it up differently? If that doesn't make sense, I'll try to clarify - just let me know.

Thanks!!


See More: fill in field automatically based on other 1

Report •


#1
June 2, 2009 at 11:04:44

Yes it is definately possible.

I have a similar thing on my access DB. I found out that it doesn't work in Tables, only on Forms.


You need to place two combo boxes on your form.
---------------------------------Region Combo Box---------------------
Properties
Name: Combo1
Control: Region
Row Source: SELECT * FROM ...................
VBA
Combo1_AfterUpdate()
Me.Combo2.Requery
------------------------------------------------------------------

-----------------------Counties Combo Box--------------------

Properties
Name: Combo2
Control: County
Row Source: (use the ... button to bring up the query builder box.) Create a query that picks up from your table containing the counties, where region matches Form.Combo1.value
-----------------------------------------------------------------------

This is only a very brief method. You will also need to make sure that the correct table relationships are inplace.

Gavin


Report •
Related Solutions


Ask Question