I am a novice programmer and I am working on VBA code in Access and need your help.

I have a list box that contains the buyers code and buyers name. This list box should have a click event that gets all of the items in the items table when a buyer is selected from the list box.

Like I said I am a very weak programmer and need your help on the code for this problem

Hi,

   This is fairly easy. Do you want the button to open a form or report? Is your combo box bound to a primary key on the buyer's table? If you can send some structure, we can do this real quick.

You will want your starting form to have a combo box that looks up the buyers in the buyer's table by PK, then displays the buyers' names and code. Is the code the PK? This should be the bound column.

Then you have a button on the form that opens another form or report that displays all the info about the buyer you have selected. Assume it is a report based a either the buyer's table or a qry of the buyers table. For the button's On Click event you would add this code:

'=====
Dim intBuyerCode As Integer 'assuming its an integer
Dim stDocName As String
Dim stLink As String

intBuyerCode = Me.cboYourBuyerComboBoxName
stLink = "[BuyerPK] = " & intBuyerCode

stDocName = "rptYourBuyerReport"
DoCmd.OpenReport, stDocName, acPreview, , stLink
'=====

If it is a form, that would be different, or if the buyer code were a string, that would require this syntax:

'=====
stLink = "[BuyerPK] = " & "'" & stBuyerCode & "'"

HTH,




mmcdonal

I have it set up to where I am connecting to the Items table in the database. Once the connection is established, I should then click on a buyer from a list box that is shown on the form. This should then retrieve all of that buyers info from the Items table based on the Buyers Code and put it in a sub form that I have.