Search results

I have a form that has two combo boxes, some text fields, and a subform. I have managed to get the combo boxes to cascade and display the correct information. But their are two problems. 1. The combo boxes only filter the first choice made in combo box one. If you try to update the selections...

You should start by defining your buisness rules. a Defedent can have many Addresses 1:M(pk must go in many table) a citiation has one defedent 1:1(the pk can go in either table) a citation has one address 1:1(the pk can go in either table) if this is correct you can make a realtionship...

Add your text field or label where you want the phone number to display. Then select the properties for this item and link it's source to tbl_admin.phone.

Change the start of your query to include 'DISTNICT" statement.

No their on the main form and are supposed to update the subform. Which doesn't work either :)

I have two check boxes(cboBranch_name & cboBranch_City) cboBranch_name displays the correct information. cboBranch_City is supposed to filter it's list depending on what selection you make in cboBranch_Name. But instead it opens a dialog box asking for input. I have entered the following code in...

I have added the following to the after update section of the second combo box. event procedure: Me! Branch_City.Requery Me! Branch_City.SetFocus But the Second combo box(cboBranch_City) still dosen't update from the first Combo Box(cboBranch_Name)?

I have two problems: 1. I have a Form with a subform thats needs to be updated from the Combo boxes on the Main form. When i select the relevant data(Branch_Name, Branch_City) in the combo boxes nothing happens on the sub form(Service Record). The Combo boxes are called cboBranch_Name and...

I am attempting to Synchronize two combo boxes. I have managed to get the first combo box to produce the right Branch Names. But the Second Combo box is empty and i don't know why. The Two combo boxes are supposed to filter branch names and citys from the same table(Branch). The row source...

I have attached a screen shot(zipped) of the database. As you can see the combo boxes are on the main form and there is a service report subform. I want the subform to refresh depending on the selection made in the combo boxes. Also the Second combo box should limit it's selection(branch_city)...

The combo boxes are on the main form. How do i update the subform from them. They where originally text fields and i change them to combo boxes, so the don't update the subform anymore.

I am desiging my companys service database and have run into a couple of problems. I have a main form that contains two combo boxes. Both combo boxes display the information that they are supposed to. But when i selection the data from the combo box it dosen't update the subform. I want the...

How do i setup a text field as a search field. ie enter in a string in txtbx_branch and have it look thorugh the relevant records it is related to. Any help with this would be great.:D

I have two problems, 1. I have a text field set to allow 255 characters, but this is not enough space, i have also tried adding vertical bars, but this dosen't make a difference. How can i get more room, i found some information that said that memos would answer my problem, but i couldn't find...