By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,153 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Trying to create a FORM / SUBform

P: 29
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.PhysicianName, 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
Oct 29 '08 #1
Share this Question
Share on Google+
2 Replies


P: 93
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
Oct 31 '08 #2

P: 29
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
Nov 3 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.