sychronize combox box, list box

[Denver]

I have a form which has a subform on it and both are based on same query..
I have a combo box (Site Location) that filters particular location..
I have a list box too with a RowSource [Drawing Type]

I want to limit this Drawing Type field after combo box is updated, is it
possible?
the reason I am using list box is because in the Drawing Type field I can
select number of values from it, is this possible too?
and After I made my chooses from the List Box it will filter based on the
selection from the list box? please show me some codes for this... I am not a
programmer please if as much as posible try to elaborate all the codes....

thank you

 

[Hunter57]

Hi Denver,

This is really something that is too much to give you the code and
instructions on this site. You can download some free sample databases that
demonstrate how to do what you want at this site:

http://rogersaccesslibrary.com/

Great Tutorials on this site:
http://www.functionx.com/vbaccess/index.htm

A Google search will turn up a lot of information about this.

Wish you the best,
Patrick Wood
http://gainingaccess.net
Free Tutorial series on building a Date Dialog Form you can use with Forms
and Reports, and working with Outlook from Access.

 

[Denver]

thank very much this much helpful to me.

thank you

Hi Denver,

This is really something that is too much to give you the code and
instructions on this site. You can download some free sample databases that
demonstrate how to do what you want at this site:

http://rogersaccesslibrary.com/

Great Tutorials on this site:
http://www.functionx.com/vbaccess/index.htm

A Google search will turn up a lot of information about this.

Wish you the best,
Patrick Wood
http://gainingaccess.net
Free Tutorial series on building a Date Dialog Form you can use with Forms
and Reports, and working with Outlook from Access.

I have a form which has a subform on it and both are based on same query..
I have a combo box (Site Location) that filters particular location..
I have a list box too with a RowSource [Drawing Type]

I want to limit this Drawing Type field after combo box is updated, is it
possible?
the reason I am using list box is because in the Drawing Type field I can
select number of values from it, is this possible too?
and After I made my chooses from the List Box it will filter based on the
selection from the list box? please show me some codes for this... I am not a
programmer please if as much as posible try to elaborate all the codes....

thank you

 

[Hunter57]

Hi Denver,

You are most welcome. Thanks for posting back and letting us know that it
worked for you. This can help others who are reading these posts also.

Best Regards,
Pat Wood
http://gainingaccess.net
Free Tutorial series on building a Date Dialog Form you can use with Forms
and Reports, and working with Outlook from Access.

thank very much this much helpful to me.

thank you

Hi Denver,

This is really something that is too much to give you the code and
instructions on this site. You can download some free sample databases that
demonstrate how to do what you want at this site:

http://rogersaccesslibrary.com/

Great Tutorials on this site:
http://www.functionx.com/vbaccess/index.htm

A Google search will turn up a lot of information about this.

Wish you the best,
Patrick Wood
http://gainingaccess.net
Free Tutorial series on building a Date Dialog Form you can use with Forms
and Reports, and working with Outlook from Access.

I have a form which has a subform on it and both are based on same query..
I have a combo box (Site Location) that filters particular location..
I have a list box too with a RowSource [Drawing Type]

I want to limit this Drawing Type field after combo box is updated, is it
possible?
the reason I am using list box is because in the Drawing Type field I can
select number of values from it, is this possible too?
and After I made my chooses from the List Box it will filter based on the
selection from the list box? please show me some codes for this... I am not a
programmer please if as much as posible try to elaborate all the codes....

thank you