I have one remaining issue with my current project. Was hoping someone might have a suggestion.
I have two tables. tblClientGeneral and tblAssetTags. Linked 1-Many on Client_Id.
Main form, frmClientGeneral it pulls Client_id and Client_name, there is a also a subform frmAssetList which shows all assets for said client.
Here is the issue. If there are no assets for that client yet, the client_id in tblAssetTags is not populated, since there are no records. So when I open my add client asset form from the subform with a command button passing the client_id to that form, it's empty. hence the asset i'm adding has no idea where to go.
So what is the best solution here? Should i set client_id on the frmAssetList to = the value of Clinet_id from the frmClientGeneral if so how? Or is there a better way to go about this. Or do I pass the client_id straight from the frmClientGeneral and not the subform.
Thanks
Bruce
I have two tables. tblClientGeneral and tblAssetTags. Linked 1-Many on Client_Id.
Main form, frmClientGeneral it pulls Client_id and Client_name, there is a also a subform frmAssetList which shows all assets for said client.
Here is the issue. If there are no assets for that client yet, the client_id in tblAssetTags is not populated, since there are no records. So when I open my add client asset form from the subform with a command button passing the client_id to that form, it's empty. hence the asset i'm adding has no idea where to go.
So what is the best solution here? Should i set client_id on the frmAssetList to = the value of Clinet_id from the frmClientGeneral if so how? Or is there a better way to go about this. Or do I pass the client_id straight from the frmClientGeneral and not the subform.
Thanks
Bruce
