Populating a subform

I have a main form whose only feature is a single combo box. This combo box contains numbers corresponding to differrent personnel names. These numbers can occur in one of two fields in a record, but not both. I would like to be to populate the subform with all the records in which this number appears. Any ideas?

Hey grangla!
So you want to get from the DB all those people that have that number (in any of those two fields) ?
write down a query like

SELECT * FROM <your table> WHERE <field 1 with number> = <number in question> OR <field 2 with number> = <number in question>

For example:

Table: bla
Field1: IDemployee
Field2: SocialSN
Number in question: 32156

SELECT * FROM bla WHERE IDemployee = 32156 OR SocialSN = 32156

The value from the combo box in your main form would be the <number in question>.

Hope that's what you ment!

ANibal.

Thank you so much. Your fix worked very well!