Trying to create a FORM / SUBform from Query

[Adigga1]

Hello,

I am running into an issue whereby, I'm attempting to create a form using a combo box selection (CPTcode). Once I make this selection the Charge price should auto populate accordingly. I'm having a very hard time accomplishing this.

I m trying to build the form from a query; The SQL code is as follows:

SELECT T_Ccpt.CptNum, T_Ccpt.Charge, T_Ccpt.PhysicianName, T_Ccpt.CPTcode
FROM T_Ccpt
ORDER BY T_Ccpt.CPTcode;

Once I've gotten this to work I need to use it as a subform.

Please help,

Adigga1