Opening form with data from table to edit.

[BukHix]

In the past I have went about this a couple of different ways but I have never found a way that I thought was foolproof so I will ask here.

What is the best way to fill a form with one record (chosen from previous form) to edit. I basically want to duplicate the entry form but have it open from a form menu where the user types in the record number. Once the number is selected, I want to open the edit form will all the data from the table filled in.

I know how to open a form and put data in a field but I need to grab the entire record set and make it editable.

Any suggestions?

 

[David R]

There is a help file, "Synchronize records between two forms"

That should help you do what you want. Essentially you'll use the WHERE clause to open the correct record.