Mutli-Combo, Multi-Table, VBA Code?

[aaronjmack]

I have three combo boxes (R_Month, R_Year, R_Time) on a form w\ a command button, based off of a table (Requests) with an autonumbered primary key (Request_ID) and a column called Service_ID.

When the user selects data in the three combo boxes, then clicks the command button, I need to check a table (Services) containing three columns (S_Month, S_Year, S_Time) to find a match.

If R_Month=S_Month, R_Year=S_Year, and R_Time=S_Time then I want to get the autonumbered primary key (Request_ID) in the Services table, and place it into the Request_ID column in the Requests table.

Can someone help me with this?

Thanks,

Aaron