Search results

I got it, finally. Thanks for you help wayne, i wouldn't have got it with you.:D

Wayne, I changed the query to include branch_name and branch_city, but the form only updates when you have from cboBranch_Name.uggh. I have tried reversing the query order of branch_city and branch_name. When you put branch_name before branch_city it stops working completely. I have a screen...

Somebody else wrote the attached query, it filters my form by the first combo box(branch_name). I want it to filter the form by both combo boxes cbobranch_name and cbobranch_city. It would be good if somebody could help. Cause this is the last thing to do on my companys database, then it's...

i'm not using a query. I have some VB(previously provided) in the cboBranch_Name(AfterUpdate), but that's it. I don't know how the subform and text fields work but they do.

The subform and the text fields are linked togther and work when you use the records arrows to scroll through. But selections in the combo boxes have no effect on them. How do i correct this?

To get the combo boxes to work i did the following in cboBranch_name. Row Source: select distinct branch.name from branch order by branch.name after update: on error resume next cbobranch_city.RowSource = "SELECT branch.city" & _...

it's based on one table, Branch. Table Branch PK Branch_id FK Client_id branch_name branch_city branch_contact branch_address branch_state branch_post branch_phone

I have attached a screen shot, hope it helps.

Wayne, The combo boxes are just used to filter the relevant customer details. The text boxes display the information. cbobranch_name =choose from 15 different branch(clients) cbobranch_city = (filtered) choose from cities The text fields and subform should now show the contact...

The combo boxes are unbound. The text fields are displaying their field attribute, e.g branch_contact

I have finally managed to get my combo boxes working correctly. They cascade correctly and show the right information. But now my text fields and sub form don't update from their selections. cboBranch_Name cboBranch_City txtBranch_Contact txtBranch_Phone txtBranch_Address Their is also a...

I already tried using an lookup. =DLookUp("[Branch_Contact]","Branch","[Branch_City]=" & [ Forms]!MainForm!cboBranch_City & " And [Branch_Name]=" & Forms!MainForm!cboBranch_Name) This just returns a wild card error. So i am really frustrated with this.

The branch table is as follows, as far as i can tell all the fields are dependent on the PK. But if you think their is something wrong, let me know. Table Branch PK Branch_Id Branch_Name Branch_Phone Branch_Contact Branch_Address Branch_City Branch_State FK...

This would work but what the other fields, address, postcode, state etc.. That mean would putting everyfield in an different table, in think thats bad design. Also there should be a way to retrieve data within an table to a text field. It shouldn't be this diffcult to do something so basic.

I am attempting to populate text box Contact_Name. The contact name should be selected from the choices made in two combo boxes, cboBranch_Name and cboBranch_City.There are many different cities in a branch_name, but each city has one branch contact. All these fields are in one table, Branch. I...

I have entered the following in the control source of a text box. But it dosen't work and every time i open the text box again in design mode, the script is missing. I am trying to display a contact name(in a text box) from a selection made in two combo boxes, cboBranch_City, cboBranch_Name...

I have written a query that works, it's output is a contact name. I am trying to have two combo boxes define the contact name. combo 1 branch_name combo 2 branch_city text box branch_contact The user makes a selection in each combo box so the contact name will then appear in the text field...

I would be happy to learn the VB code, i have done java programming, but never learnt VB.

I am attempting to have a contact name displayed in text box Branch_Contact. But the result depends on the selection made in the two previous combo boxes cboBranch_Name and cboBranch_City. I have made a Query(branch Query) that displays the contact name when run by it self, but when inserted in...

I have managed to sync my combo boxes to filter and update with the correct information(only took me two weeks, lol). But now i am trying to update the text fields below them with the filtered selection from the combo boxes. combo box 1= Branch_Name combo box 2= Branch_City Text field 1 =...