Search results for query: *

hey thanks a lot...I made some small changes and it worked!!.I added the .value to customerID update also. Thanks again :)

Private Sub CustomerID_AfterUpdate() If (Me.CustomerID.RowSource = "qryCustomerName") Then Me.CustomerAccountID.SetFocus Dim strSQL As String strSQL = "SELECT DISTINCT tblCustomerAccount.CustomerAccountID, tblCustomerAccount.CustomerAccount" strSQL = strSQL & " FROM tblCustomerAccount WHERE...

hi thanks for replying The controls are bounded.There are 2 queries used as rowsource for both the boxes along with the rowsource for displaying all the names and numbers for the customer to select from.The queries are passed using code depending upon whether the user selects name or...

In my application i have 2 comboboxes displaying name and number.If i select name from 1 st combobox the second one displays the corresponding number.But the issue is that for the first time when i select name from 1st combobox, the value in the 2nd combobox will be displayed only after I click...

hi all.. It works fine but the problem is that the customer name and customer number are in two different tables which have a common field called custmerID.I completed this using the double click and on click event of the two combo boxes such that if the name combobox is double clicked then it...

hi I am creating an application where in there are two comboboxes.one contains the customer name and the other thecustomer number.I want the comboboxes to work in such a way that if the user wish to search using customer name it should automaticaly fetch the customer number and display in other...