S
Simon
Hi
I am 100% new to access but quite experienced in SQL. (SQL Server 7,
2000). I am not used to producing applications but rather stored
procedures and other forms of queries.
What I want to do in a form is to bring back results based on drop
downs which lookup to "lookup tables."
For example - at the top of a form have a section of drop down boxes:
Firstname
Lastname
PostalCode
Once these have been filled in by some form of lookup, a button or
something is executed to bring back a decent result set based on the
selection criteria.
It appears in access that if you want to produced forms against
queries with parameters, it first prompts you to "fill in the blanks"
prior to you seeing the form. Whereas in other apps, you have a series
of drop downs that bring back the information. Thus, you cannot parse
through information selected on a drop down... or a set of drop downs.
In my example, I'd like to see all the John Smiths in London. So the
firstname box has a distinct list of first names, the same for the
lastname box and then again for postal code. All reside in lookup
tables individually.
How... on this green planet can you do this? I've searched the web,
bought two books and no one seems to cater for what is arguably in
every application I've ever seen.
I know my example is rather simple but it seems the best way for me to
explain it.
Your help is appreciated and you can mail me directly at
(e-mail address removed) since we have a first class firewall and the
google groups mail address is not allowed past.
Helping me with this, in a very simple manor, will be truly
appreciated.
With thanks in advance!
Simon
I am 100% new to access but quite experienced in SQL. (SQL Server 7,
2000). I am not used to producing applications but rather stored
procedures and other forms of queries.
What I want to do in a form is to bring back results based on drop
downs which lookup to "lookup tables."
For example - at the top of a form have a section of drop down boxes:
Firstname
Lastname
PostalCode
Once these have been filled in by some form of lookup, a button or
something is executed to bring back a decent result set based on the
selection criteria.
It appears in access that if you want to produced forms against
queries with parameters, it first prompts you to "fill in the blanks"
prior to you seeing the form. Whereas in other apps, you have a series
of drop downs that bring back the information. Thus, you cannot parse
through information selected on a drop down... or a set of drop downs.
In my example, I'd like to see all the John Smiths in London. So the
firstname box has a distinct list of first names, the same for the
lastname box and then again for postal code. All reside in lookup
tables individually.
How... on this green planet can you do this? I've searched the web,
bought two books and no one seems to cater for what is arguably in
every application I've ever seen.
I know my example is rather simple but it seems the best way for me to
explain it.
Your help is appreciated and you can mail me directly at
(e-mail address removed) since we have a first class firewall and the
google groups mail address is not allowed past.
Helping me with this, in a very simple manor, will be truly
appreciated.
With thanks in advance!
Simon