Recent content by jon2371

Thanks, i need to warned the user before deleting the record...where do insert the msgbox, or do you sample vba code for delete button.

Hi Experts, i have a form and i need to create a button in a form to delete a record, do you have a sample form for this. thanks, Jon

Thank You...

Hi Experts, i have created a two textboxes (1) cboItemCode (2) txtItemName. The rowsource of the cboItemcode is a query (ItemCode , ItemName) and if i choose the specific itemcode, the itemname will also appear in txtItemName Textbox. how can i do this in AFTERUPDATE in cboItemCode. Thanks, Jon

thanks a lot....

Hi Sir, Primary Form Name : HeadRejectMachF SubForm Name : DetailRejectMachSF i have created a textbox (txtTotalQty2) in footer of DetailRejectMachSF, and need to link to textbox (txtTotalReject) in MainForm. Thanks, Jon

Thanks Sir, here's my database

No Sir, the Sum is not working in subform footer

i tried to remove the =sum in =sum(txtqty2) in subform footer textbox and it works... but if i used the SUM there the error "#ERROR" in mainform textbox.. :banghead:

Thanks i already fixed the error.. thanks a lot

i tried to remove the Form. the error is #Name? Thanks.. Jon

Hi Sir, I created a TextBox (txtTotalQty2) in SubForm footer and type a formula in Control Source Property. =Sum([txtqty2]) And also created a TextBox (txtRejectTotalQty) in Primary Form and type a formula in Control Source Property =[DetailRejectMachSF].[Form]![txtTotalQty2] But i...

Hi Experts, I created a Primary Form & a Sub Form (datasheet), the subform have a QTY Field and i need to sum this QTY Field and make it appear on a textbox in Primary Form. Please help. Thanks, Jon

This is the exact error if i load the Form. Run-Time error '2465': Reject Project can't find the field 'DetailRejectMachSF' referred to in your expression.

Hi Sir Alex, Still encounter error on Form Load, the txtpostingdate2 textbox is still visible.:banghead: This is my syntax: --------------------------- Private HeadRejectMachF_Load() Forms!HeadRejectMachF!DetailRejectMachSF!txtpostingdate2.Visible = False End Sub Please Help... Thanks, Jon