Find Record/SaveRecord

[RaunLGoode]

I want to do exactly what a "Find Record" and "Save Record" comand button would do, but with Code. I need the Object/Property to do this.
Specifically, I want define a Record number based on a variable, modify the record, and then Save the record. (The Record number is a Primary key.)

Dim RecNum as Integer
[find record].RecNum
.....
[save record]... or would that be Update.Record

could somebody help me?

 

[G@bor]

To save the record you can attach the following to an event (e.g. click event of a button called ... save, maybe?)

DoCmd.RunCommand acCmdSaveRecord

HTH

Gábor

 

[RaunLGoode]

Thanks, I will give this a try.