open form to specific record

[Harry Shmedlap]

I have a table, called TableData with several records. The form to view this table is called FormData which is formatted to show only one record of TableData.

Another table, TableConfig, has only one record and is used to shows my current configuration. One field, FieldDataCurrent, is the ID of the record last selected in FormData.

How do I do the following:
When FormData is opened, it reads in TableConfig.FieldDataCurrent and displays the corresponding fields for that record?

Thanks in advance

 

[RuralGuy]

MVP Allen Browne has just such an example:
Return to the same record next time form is opened

 

[Harry Shmedlap]

Thanks.
Thats just what I needed!

 

[RuralGuy]

Glad I could help.