Search results

wait , the subform is continuous , and i use keyboard arrows to move between its records , on that subfrm there combobox cboItemNo , i move to tha new record by using keybord arrows down to insert new record , when i use requery or recalc it jumps to the first record on that subform .

plz understand me . the txtT2 textbox is on the main form to gives me the total of a PriceService field on the subform . what this code and under which event ?

txtT2 textbox is bound to this expression : =CLng(nz(DSum("PriceOFSer";"OrderDetailTbl";"OrderNo=" & [OrderID] & " AND TitleServi=" & 2);0))

yes of course .

i try it , but it return to the firsr record on that sub form

under which event ?

yes txt2 on the mainform , bound to an expression

i try that code under the itemid after update , then under the subform after update but it didn't update the txt2 textbox .

hii dears on main form a textbox ( txt2 ) to gives me the total of subform some field how to requery that textbox ( txt2 ) after user add new item on the sub form without return to the first record on the subform ?

i could not give the same control subform for more than one subform on that same Mainform .... could you gives me some example ?

Coul Could you explain step 1 or change my code to meet my request

hii all i have a main form with a tab , 9 sub forms i notice navigation between records become slow , then i search for a solution , i find this code : Private Sub ps_Change() Select Case ps.Pages.Item(ps.Value).Name Case "pg1" ' Where sfrm1 is the name of the subform on page 1 If...

Mr Pat See , i use this expression on the orederdate testbox validation rule : <DateSerial(Year(Elookup("MyDefaultDate";"tblDefaultDate";"MyDefaultDayID=1"));1;1) And >DateSerial(Year(Elookup("MyDefaultDate";"tblDefaultDate";"MyDefaultDayID=1"));12;31) Then use this code Option Compare...

Thanks Mr Pat Hartman . Have you downloaded my attached file ?

See to that sample ... I use beforeupdate event with some code but didn't works good.

Yes of course. Later .

Hi dears I have a form on it textbox for dates , it validation rule is between 01/01/2022 and 31/12/2022, i use a popup built-in calender form to select dates . But the validation rule didnot work except when user insert the date by keyboard or using the access popup calendar . How to make...

hiii dears i have a db to collect the services of polyclinic center that handle with insurance companies and thier costumers. - tblBillHead : contains a field companyID (fk connected to tblCompanyData on Pk CompanyID) - tblBillDetails (conjunction table) : contains ServiceNo , BillNo ...

it sloved thanks

thanks it solved . but what if MainFrm on new record and InsurCmpName is null ? ( err 3075)