Hello,
In my access database I have one simple table called "Transactions" like this with example data
http://img96.imageshack.us/img96/268...1220142554.jpg
and all that data will be pulled on specific way through one simple form called "Test form". It should all work similar to this
http://img818.imageshack.us/img818/1...1220140354.jpg
This is detailed explanation..
When user clicks on combo box CUSTOMER there is After update Event that will contain loop that will search all data in Table "Transactions" and then at the end show that customer "A" has two invoices no. '1' and '3'
In case user chooses customer "B" then subform will show result invoice no. '4' and etc.
Is this possible, what code I should use at After update Event of combo box CUSTOMER?
Any help is appreciated and many thanks in advance for prompt replies!
Cheers,
Adi