Search results
-
J
Using data from one form to search in another.
Im sorry, I did'nt really understand and so I took what you had said, put it into a macro which I did understand and then converted it back to VBA. DoCmd.OpenForm "frmRepairInv", , , "[Invoice Number]='" & Me.[Invoice Number] & "'" This is how I have it now but I get a 'data type mismatch in... -
J
Using data from one form to search in another.
Thank you, It switches form and puts a filter on it but doesn't actually find the corresponding record. DoCmd.OpenForm "frmRepairInv", acNormal, "", "[Forms]![frmRepairInv]![Invoice Number]=[Forms]![frmRepairBooking]![Invoice Number]", acEdit, acNormal Any ideas where I am going wrong? Regards -
J
Using data from one form to search in another.
Afternoon, Im a newbie so hoping someone can help. Using either a Macro or VB Script I need to take an invoice number from one form, switch to another form and find that invoice number in the second form. Im really struggling and it seems a basic request. Could someone help me. Many thanks -
J
Subform Total In Main Form
Awsome. Thank you so much. That worked perfectly. -
J
Subform Total In Main Form
Hello, Sorry to dig up a really old query but im struggling with the same issue. No matter what I do I cannot seem to get the total of the field [S Total] in [tblSalesinv subform] to add up into the field [S Total] in the main [frmSalesSheet]. IF you click menu to start, then click sales and...