asked on

Search question

i have a form with 3 textboxes across called

"Product description", "UnitPrice" and "Discount"

i have coppied these down in a control array ie

txtProductDescription(1)
txtProductDescription(2)

etc for each of the 3, what i would like to know is whenever i type in a product in the product description textbox it searches the "Products" table in my Access database and updates the other fields across with the appropriate information. How could i do this? and make it work for each txtbox down?

i am using the standard data control

thanks for any help!

alaplume

The control array will share a change event and provide and index telling you what control has focus.

ASKER CERTIFIED SOLUTION

appari

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

digitaldestruction66

ASKER

thanks appari, i modified it a bit but it doesn't seem to compile, can you help please? I have upped the points to 200. The code is below

Private Sub txtProductID_Validate(Index As Integer, Cancel As Boolean)
Dim RS As Recordset
Dim strSQL As String
If txtProductID(Index) <> "" Then
'**** Get Data from tables
datProducts.RecordSource = strSQL
strSQL = " Select * from Products where ProductName=" & txtProductID(Index)
'create recordset using ur connection
If Not RS.EOF Then
txtUnitPrice(Index) = RS("UnitPrice")
'txtDiscount(Index) = RS("discount")

Else
MsgBox "no data found for this product"
Cancel = True
End If
End If
End Sub

i am a beginner at this so an explanation would be excellent, the more help i get the more points you get!

cheers

DD66