Need a combo box to display different lists depending on a control

[SaraRob]

Hi, I'm not sure how to write something and would like assistance. The form is taken from a table and then there are two diffenterent forms displayed as datasheets within, on tab controls. I have a combo box taken from a query on each form and would like the combo box to display a certain list if the control on the form (the bit taken from the table) has a P in it, a different list if the control has an R in it or to display the whole list if the control has a B in it. Trouble is, I'm quite new to this and I'm not sure on how to write any code for if statements or whatever is needed. If you are able to assist I would appreciate it. Thanks

 

[ejstefl]

Hello,

Try this link: http://www.fontstuff.com/access/acctut10.htm

Its not exactly what you need, but you should be able to figure it out.