populate a combobox from table with criteria

Hi  I am using Access 2010

I have a table with two fields.  

Table Name :  MyTable

Table fields below..
[Transaction Type]     ...  Text field
[Type ID]               ...  Numeric field

On my form,  I have a combobox.  I would like the dropdown selection to show table entries of [Transaction Type]  where  [Type ID] > 2

I would like to do this in the Form Load event.  I appreciate your help.
peispudAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
private sub form_load()

me.comboName.rowsource="select  [Type ID],[Transaction Type]  from MyTable Where  [Type ID] >2"


end sub

set the combo
column count to 2
bound column 1
column widths 0; 1
0
 
peispudAuthor Commented:
Thank you.  

I'm getting through this project with some awesome help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.