forms one column based on another column

[jazz007]

Hi
I have a table called overall within this table there are a number of fields. One is called operation which is linked to a lookup table called typeofoperation mentioning colmn 1 ear, nose, throat (in a combo box). The next field operationdetails also uses the same lookup table called type typeofoperation but column 2 which has the different procedures relating to it (in a combo box).

In forms is there a way in the when the user selects operation and chooses ear using the combo box. in the next field operationdetails to only list the ear operation only and not others. basically one field is dependent on the decision made on the previos one. can anyone help.

summarise:
one table called OVERALL
many fields those in question are the following:

FIELD NAME: operation linked to lookup typeofoperation (using column 1 combo box )eg ear

FIELD NAME: operationdetails linked to lookup typeofoperation(using column 2 combo box)
eg: Removal of Foreign Body from External Auditory Canal > D073

in the form depending on what you select in operation field only those operationdetails which are for ear to be showed in field 2 and the user chooses which type.

If you have any ideas please let me know
Thanks

 

[PHV]

Simply dynamically rebuild the RowSource SQL code of the operationdetails combobox in the AfterUpdate event procedure of the operation combobox.
BTW hopefully you don't use Lookup table fields ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244