accesshelpme
Registered User.
- Local time
- Today, 15:41
- Joined
- May 13, 2012
- Messages
- 15
hey guys,
i really hope one of u guys can help me, I'm pretty desperate. I'm by no means an expert in access. other then then occaional class project, I have no experience. A few months back I i started to built a database to hold client information for a internship i worked @. I had gotten pretty far with it. The i stopped the internship for 6 months and now im back and they are running a newer version of access. I took the database home and it runs on my computer with access 2010.
heres what i need help with:
One part of the edit form has a add product/vendor button. this button bring up another form linked to another table and allows the user to add the information needed. Then when u save that record that form closes and brings u back to the origanl form. On this form under the add product vendor button there are 2 listboxes next to each other. The one on the left shows the products associated with the client and the one on the right shows the vendors that client uses for that product listed on the right. heres the problem. I did this with vd code, as follows:
Dim strSQL As String
strSQL = "SELECT Products from [Client ProdVend] " & _
"Where Client_Account_Name = '" & Me.Client_Account_Name & "'"
Me.List91.RowSource = strSQL
Dim strSQL2 As String
strSQL2 = "SELECT Vendors from [Client ProdVend] " & _
"Where Client_Account_Name = '" & Me.Client_Account_Name & "'"
Me.List93.RowSource = strSQL2
but when i open it in a the newer version of access or if i try to make it an ACCDE, it doesnt work properly. It just shows fills the list for the first client, but when i go to the next client(record) it remains unchanged and still shows that first clients prod and vendors in the listboxes.
ANY HELP IS GREATLY APPRECIATED!
i really hope one of u guys can help me, I'm pretty desperate. I'm by no means an expert in access. other then then occaional class project, I have no experience. A few months back I i started to built a database to hold client information for a internship i worked @. I had gotten pretty far with it. The i stopped the internship for 6 months and now im back and they are running a newer version of access. I took the database home and it runs on my computer with access 2010.
heres what i need help with:
One part of the edit form has a add product/vendor button. this button bring up another form linked to another table and allows the user to add the information needed. Then when u save that record that form closes and brings u back to the origanl form. On this form under the add product vendor button there are 2 listboxes next to each other. The one on the left shows the products associated with the client and the one on the right shows the vendors that client uses for that product listed on the right. heres the problem. I did this with vd code, as follows:
Dim strSQL As String
strSQL = "SELECT Products from [Client ProdVend] " & _
"Where Client_Account_Name = '" & Me.Client_Account_Name & "'"
Me.List91.RowSource = strSQL
Dim strSQL2 As String
strSQL2 = "SELECT Vendors from [Client ProdVend] " & _
"Where Client_Account_Name = '" & Me.Client_Account_Name & "'"
Me.List93.RowSource = strSQL2
but when i open it in a the newer version of access or if i try to make it an ACCDE, it doesnt work properly. It just shows fills the list for the first client, but when i go to the next client(record) it remains unchanged and still shows that first clients prod and vendors in the listboxes.
ANY HELP IS GREATLY APPRECIATED!