Filtering the CustomerNo from unbound object which taking data from query

[gstylianou]

I would like once again your assistance in a matter that i cannot solve:


In "frmCustomers" I have an unbound object which gets data from a query and gives the results in 6 columns. The first column contains the customer number (CustomerNo) and if you choose for example the third row (eg. the 3rd customer) i want to open one other form which contains the data for that customer. (frmCustomersDetails)




That?


For example , if choose the third row (which means CustomerNo=3) then when I double click i want to filter the CustomerNo and opens the second form


Thank you in advance

[gstylianou]

this is one picture which can make me more clear

[pbaldy]

Does this help?

http://www.baldyweb.com/wherecondition.htm

[gstylianou]

It's not exactly what is my problem ... I have knowledge on how can filter the CustomerNo. What actually is my issue is how can filter the existing row in order to open the second form which will be filtered on the existing record source. Please note that, the unbound object in my form (the main form) is datasheet view.


So I want to find a solution on how can i filter the CustomerNo of each line (Row) .... To be more understandable please check my uploaded photo of my unbound object that i have.


Sincerely,

[June7]

The images look identical and contribute nothing to my understanding of the issue.

Think I have the same understanding as Paul and seems the solution offered is what you need.

[Z1nkstar]

Do you have a form with just that Customers informations in it?
If so I think just a simple double click to that form that would get its data from the Customer you have chosen should do just fine.