SQL within a subform

[chillay]

I work with Access and have a database that was created by someone else that I now work with. I ran across this in a subform for one of the databases we use and was curious about [form]![combo107].

I use it to select a specific event someone is participating in but don't understand how it was set up and how it works. Any light you can shed on it would be very much apprciated.

SELECT Events.EVT_EVT_CODE
FROM Events
WHERE (((Events.PREF_ACCT_ID)=[form]![combo107]));

Thank you!

Chillay

 

[RivetHed]

It's a recordsource telling the form to show everything in the EVT_EVT_CODE field where the PREF_ACCT_ID field equals a combobox on a form called combo107.

 

[chillay]

Thank you very much RivetHed. That was so very helpful. I appreciate it.

Chillay