Displaying Text Field Data for the Corresponding Combo Box Selction.

[asdaqamin]

I am designing a database for my Bank.
But I have a problem, please give solution If you can help me.

I have a Table name "BranchName",purpose for entering Branches of Bank.
Fields are as below.
SrNo. (Auto Number)
BrName (Text)
BrCode (Number)
Region (Text)

Now I had made a Form "Branch".
On this there is one Combo box in which all "BrName" are shown.I made that.
Now I made another Text Field where I want to show the corresponding "Region" automatically appears for the selected "BrName" .

Now how I make this.Any Query or Code Builder Event ??????

 

[FoFa]

On the ON-CLICK event of your combobox, assuming the SrNo is the bound field, just use a DLOOKUP to populoate the text box, something like:
Me.Region = Dlookup("Region","BranchName","SrNo. = " & Me.MyComboBox)