J
jordy
I've got a problem for several weeks now, and i'm not able to solve it.
I've got a database with data from a sharepoint connection, it's a expanded
contactlist with lots of extra fields in it, for example specialty
what i want toachieve is the following:
a form with a drop-downlists where the specialty is chosen. then a query
should select all contacts with that specialty.
I used to this with the form still open and then have the query look in the
form which variable was chosen. in the query based on a sharepoint list an
extra colom is added with the specialty.value and the criteria are moved to
that colom so it will not work anymore.
if it was just one drop-downlist it wasn't a problem but there are about ten.
I've never worked with VBA, so if i have to use that, please be a bit
specific ;-)
i hope i was clear on my problem and my english didn't do the explanation
much harm ;-)
thanx, Jordy
I've got a database with data from a sharepoint connection, it's a expanded
contactlist with lots of extra fields in it, for example specialty
what i want toachieve is the following:
a form with a drop-downlists where the specialty is chosen. then a query
should select all contacts with that specialty.
I used to this with the form still open and then have the query look in the
form which variable was chosen. in the query based on a sharepoint list an
extra colom is added with the specialty.value and the criteria are moved to
that colom so it will not work anymore.
if it was just one drop-downlist it wasn't a problem but there are about ten.
I've never worked with VBA, so if i have to use that, please be a bit
specific ;-)
i hope i was clear on my problem and my english didn't do the explanation
much harm ;-)
thanx, Jordy