Hi everyone.
I am trying to create a query based on responses from a user on a Access form. What I am trying to do exactly is there is a create the query from a table named WCNVACCT which has about 12 fields name, account number, etc. The first combo23 will ask form the item (ie. name) and the second combo25 will ask for the detail of that item (ie "John Smith"). I was trying to do something like this in the event procedure of a command button: SELECT combo23.Value FROM WCNVACCT WHERE = Combo25.Value.
Any suggestions? DAVE
I am trying to create a query based on responses from a user on a Access form. What I am trying to do exactly is there is a create the query from a table named WCNVACCT which has about 12 fields name, account number, etc. The first combo23 will ask form the item (ie. name) and the second combo25 will ask for the detail of that item (ie "John Smith"). I was trying to do something like this in the event procedure of a command button: SELECT combo23.Value FROM WCNVACCT WHERE = Combo25.Value.
Any suggestions? DAVE