I have been trying for a week now to get rid of the bugs in this form but I am obviously missing knowledge and information.. Hopefully you can help me.

Tables
- Tbl_customer contains info on client. Unique key is CCAN
- Tbl_dda_app: contains info on the client’s Approvals. Key is [dda_no] which is an autonumber
- Tbl_dda_ast: contains info on one or more Asset (record) per Approval. Each asset is numerated with the field [ast_no] starting at 1 for each Approval.
The key field is [app_no] which is the combination of = ast_dda_no & "-" & ast_no

Relationships
Tbl_customer.[ccan] ___ one to many ____ tbl_dda_app.[ccan]
Tbl_dda_app.[dda_no]__ one to many _____tbl_dda_ast.[ast_dda_no]

The business logic is as follow

1 The user selects the client in a drop down
2 In the application subform, the user can create or amend Application for that CCAN
3 In the asset subform, the user selects one of the Application for that client, then create /amend data located in tbl_dda_ast for the Assets related to the Application in a subform.

Steps 1 and 2 are working perfectly..

Main form [frm_dda] with recordsource [qry_frm_dda] with the data selection made by the combobox [cmb_frm_dda]. Selection is made by the field [ccan].

The Application subform [frm_sub_dda] with recordsource [qry_frm_sub_dda] lists all [dda_no] for the [ccan] selected.

I have an example of the database located at

http://www.4shared.com/file/105192585/439b5ec7/WCM-F-2000.html

My issues are

1- In the asset subform [frm_sub_ast], get the a drop down that list all [dda_no] selected in the previous subform [frm_sub_dda] that can be updated on the fly
2- Select from the drop down above the list of assets that have the same dda_no as the drop down.

Can someone point me in the right direction? After 100 or so attempts at this, I still cannot get the drop down updated when a new dda_no is created, or there are still several errors when an asset is created etc..

Thanks in advance.

I looked at the database and there is no frm_sub_ast. Do you have another copy of this. You need to put an after update and after insert events on the subform to requery the other subform, I think. Do you have a copy with all the forms and subforms you mentioned?

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

Thanks for the reply. I amended the structure and found another way of doing this with a subform within a subform..