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!