Code to automatically complete control

N

Nick Mirro

A form has a combo that looks up a service code in tblCPTCodes.

Below this combo is a control that needs to show the Fee from
tblCostByLocale.


tblCPTCodes tblCostByLocale
CPTID CBLID Autonumber
LocalID Foreign
key
CPTID Foreign key
CPTCode Fee


How can I code the "Fee" control with this logic?

Automatically show fee from tblCostByLocale based on CPT code selected in
combo control



Here is the form's query:

http://home.comcast.net/~nickmirro/images/Temporary/Query.gif

Here are the db relationships:

http://home.comcast.net/~nickmirro/images/Temporary/Relationships.pdf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you code, adding a new record? 10
Doesn't 1:1 automatically generate record in foreign key table? 5
Return node's full parentage in tree data structure 4
error referencing a subform control 2
Copy Master and Sub record to an exisiting record with specified P 15
Looking for Code to Expand Subform Rows Automatically 1
Problem locking bound controls 5
Combobox Question 6

Top