MyDB.TableDefs("tService").Properties("SubDataSheetName") = "Table. Is there a way just to requery or update the tService for the sub datasheet information to take effect? Private Sub cmdDHBs_Click() I could for sure close and open the form every time the user clicks. The problem is that sub data sheet will not automatically update, until you close and reopen the whole form. I want to be able to use a button (see facilities/see DHBs) to switch between two different sub data sheets for tService sub form. Dlookup is a slow method of obtaining the cost value. You would have better control of Null and could then use a recordset to obtain the value. The subdatasheets can be linked to either facility/DHB info of the service)(1 to 1-many). DLookUp ( Cost,Labor, ID & nz (Me Labor,0)) 2 Write a function to obtain the cost value and set the value to the function. I used a sub table (tService) rather than a sub form to show service info as I want to take advantage of the subdatasheet function that is available only to tables (the + to expand function. I have on the f3AgreeService form the Agreement itmes(parent) and Service details(child).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |