Look's like I'm becoming a regular user of this forum.
I have a form with a subform of modules that the client can be given quotes on. Recently, through the forum, I had trouble totalling the cost of the quote and was given some help by going back to the Orders.db from Microsoft.
Now with it working just the way I want, I am required to provide the user with the ability to select the prospective client from a combo box, and if already exists, then auto fill the appropriate address & phone etc. I have done this for another form but it doesn't have a subform being affected by the changes made in the rowsource.
Can any one tell me how I can achieve the auto fill which I do with two queries, one for the form and one for the combo box. The common field is QClient on the Quote table, the QuoteClient table and the QModule table. It shouldn't be a problem but it keeps dropping the Master & Child links in the subform as well as a error message saying something like...
There has been an error in the Link Module, the object
already is..... etc. although it still displays the subform, I loose the original records.
Thanks
Angelique
I have a form with a subform of modules that the client can be given quotes on. Recently, through the forum, I had trouble totalling the cost of the quote and was given some help by going back to the Orders.db from Microsoft.
Now with it working just the way I want, I am required to provide the user with the ability to select the prospective client from a combo box, and if already exists, then auto fill the appropriate address & phone etc. I have done this for another form but it doesn't have a subform being affected by the changes made in the rowsource.
Can any one tell me how I can achieve the auto fill which I do with two queries, one for the form and one for the combo box. The common field is QClient on the Quote table, the QuoteClient table and the QModule table. It shouldn't be a problem but it keeps dropping the Master & Child links in the subform as well as a error message saying something like...
There has been an error in the Link Module, the object
already is..... etc. although it still displays the subform, I loose the original records.
Thanks
Angelique
