Re: How to Find the Date of Last Change in Inventory

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I should explain that I put the code on the double click event of a
command button and when I double click it, it gives me the compile
error, variable not defined, on the line:

rst.MoveLast

That is to say, I do not get the compile error when viewing the code
and pressing the compile button.

I should tell you that the only VBA code I know how to write is your
basic If--Else Statements to make things visible or not, draw lines,
etc. I also do ones that requery, and fill in data given certain
criteria. But some are a bit more compicated than that. At times, I
can tweek complicated code I don't fully understand. But other than
that, I'm at your mercy on this one. I have no idea how to complete
this code or implement it.

I hope we can get it into some table.

Thanks,

Matt

.

Quantcast