Updating

[mithani]

Friends,

I want to create macro to update my table. How i will referene my form and field in macro.

update dailytable set recNo = 1 where fileno = form????.fileno(field)???

thanks
mithani

 

[ted.martin]

You will need to write the macro to Open an Update query

 

[mithani]

thanks ted.

I would appreciate if you could give me any example code.

thanks man

mithani

 

[mithani]

hi

I have tried this code:

update tblInvoiceParent set receivedInvoice = -1 where InvoiceNo =Forms!invoiceEntry!comPurchaseOrderNo

But updating next record. For example I want to update invoice number 1012, macro will update 1013. Any idea.

thanks

 

[mithani]

don't worry man, i fixed it.