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/
 



Reply via email to