Ohhhhhhhhh!!!!!! You are GREAT!!!!! Its been like 2 weeks i'm stuck in this problem and giving you as much info i can and after that what have u came up with ????????????
and you think you solved it ????????
Is it you call a solution ?
well i don't want to say anything .
Thanks for ur time .
see u next time ...
Your question was:
Hello everyone,
I have a form with subform (datasheet) .
On my subform i have one field which shows the
productId ( which is filtered from combo boxes on main form) .
productId contains two columns
1 bound column(id) ( hidden with width 0 )
2 column (desription) ( shown with width 2 )
Now after entering the data when i come back to the form again . It hides the data from the productId field on subform , because data in combo box (on main form) doesn't match. Although the row is showing up , only the text in field (productId) is hidden.
Now when i change data in combo box on main form to match the ProductId , then the productId field text shows again.
after changing combo box it hides . What i need is the existing data should not hide when i change the combo box selection.
see pic 1 where product matches and pic 2 where not.
please note i am using master child relationship on the form/subform.
Please help and ask for more info if needed.
Thanks .
and you think you solved it ????????
Yes ... Solved
The reason you are upset is you already knew what was wrong didn't you..
I reckon you had it working OK but didn't like the way the Combo returned 1000 records, so you added the complicated SQL statement, and it broke.
If you'd said that right at the beginning, then we would have got to the real problem 2 weeks ago.
There are at least 2 ways of solving the problem I can think of, which is why I drafted the NEW question for you to put in a NEW thread.
A new thread offers the opportunity for someone to provide a solution. Failing that, I will suggest a couple of ways it could be done.
