Sabtu, 24 Oktober 2015

Re: [MS_AccessPros] Limit combo box in continuous form

 

Hi Kevin,

do not see your previous message, perhaps it did not go through.  Be sure it is included before you click send.  If using an interface that does not include the previous message, you will have to click on a link to do so -- thanks.

please realize that a combo box is the SAME on all records.  So if you want to limit choices for information on a current record, I find it best to use the GotFocus event to set the RowSource limiting choices and then the LostFocus event to show all choices again.  Realize that while you are picking, information in other records for the combo may be blank because of the criteria.

warm regards,
crystal

~ have an awesome day ~


On 10/24/2015 5:05 PM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] wrote:

Dear All,
I posted this topic yesterday, haven't gotten feedback yet. Maybe the question wasn't too clear, so I rewrite it here. I want a combo box in a continuous form to be limited by another field in the current record (record with focus in continuous form). Can this be done? Thanks.
Best Regards,
Kevin



__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar