DoCmd.FindRecord problem

[BrenoAguiar]

HI folks,

I wanted to use one form (form1) to edit records in a table (tbl1) and after updating the record, the command button should open another form (form2), BUT ON the same record that he was updating on Form1, using the field "Media_cd" as the link. i.e. [Forms]![form1]![media_cd] = Me.Media_cd

I wanted to use the ".FindRecord" and not open the form1 with the [media_cd] FILTERED.

Any Help ?

 

[PHV]

Have a look at the RecordsetClone, FindFirst, NoMatch and Bookmark methods/properties of the Form/DAO.Recordset objects.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886