Hi,
The rowsource property of the combo box on a sub-form which is in datasheet
view doesn't change as per the selection in the main form. What could be the
reason.
I have a Main form where I select Vendor ID. As per the selection in the main
form the BillNumber combobox on the sub form should only show the bills
pertaining to the selected vendor on the main form. I have designed a query for
that which works fine if run through query design, but when I assign the query
to row source property the actual row source doen't change as per the selection
in the main form. The row source property doesn't change for subsequent
selections once it is set by the very first selection on the main form.
Please help,
Rajesh Desai
---------------------------------
Here's a new way to find what you're looking for - Yahoo! Answers
Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it
NOW
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Groups gets a make over. See the new email design.
http://us.click.yahoo.com/WktRrD/lOaOAA/yQLSAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/