Trying to create a FORM / SUBform

[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:


[PHP]SELECT T_Ccpt.CptNum, T_Ccpt.Charge, T_Ccpt.Physicia nName, T_Ccpt.CPTcode
FROM T_Ccpt
ORDER BY T_Ccpt.CPTcode;[/PHP]

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


Please help,

Adigga1

[emsik1001]

Hi

I undestand that you have a form with the fields from the table and you want to add 'combo box' control from the toolbox and in the wizard (which should appear) you selected 'I want the combo box to look up the values in a table or query'+ correct table and field. but it still doesn't work?

Is that correct? ... I'm just trying to understand where the problem lies.

Regards
Emil

[adigga1]

Hi

I undestand that you have a form with the fields from the table and you want to add 'combo box' control from the toolbox and in the wizard (which should appear) you selected 'I want the combo box to look up the values in a table or query'+ correct table and field. but it still doesn't work?

Is that correct? ... I'm just trying to understand where the problem lies.

Regards
Emil

Yes, that is correct, I've been attempting to get this to work for weeks.

regards,
adigga1