Combo Boxs please help

[Shnea]

I have a form called "Make New Work Requests" with a combo box with all out clients listed. what i want to do is have it so when i select a client it fills out the address, phone numbers. clients name etc which is all stored in another table called "Universal Access Clientele Database". also my "Make New Work Requests" form saves all the data in to a table called "Work Request"

Please help me

 

[BLeslie88]

Correct me if I am wrong...

You need to store the value of the index you are refering into the combo box assign it to the other form when opening it... Such as...

Function Open_form(Form As String, vSearch As String)
On Error GoTo Err_Open_form

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = Form
stLinkCriteria = vSearch ' Index from Combo Box
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Open_form:
Exit Function

Err_Open_form:
MsgBox Err.Description
Resume Exit_Open_form

End Function

Hope this helps...
Brian