Show current record in a new form

[inf33323]

Hi there,

I have a form displayed in a table layout. Each record has attached a button. I want to show further record information in a separate from when clicking on the button next to the record.

Following code is attached to the button:

Dim ActForm As Form
Set ActForm = Form_UnterformularMainAssets
DoCmd.OpenForm ActForm.Name
DoCmd.GoToRecord acDataForm, ActForm.Name, acGoTo, ActForm.CurrentRecord

Clicking on the button opens the desired form, but always showing the FIRST record and I don wanna see this.

I would appreciate any idea. Thanks a lot,

Christa

 

[LonnieJohnson]

I'm not exactly sure what you mean by current record. If you are talking about Form_UnterformularMainAssets's record matching the record of the orginal form, then maybe consider using a query as a record source to Form_UnterformularMainAssets and the criteria for query will be a unique identifier, such as ID number or SSN.

If this doesn't help, give me more detail.

ljprodev@yahoo.com
Professional Development
MS Access Applications