Windows Forum·65,836 discussions

Access 97 Simple Question

Locked

I need to push a button on a form and go to a second form showing only information for the current record (showing on form 1). This is all dealing with a single record in a single table. It sounds simple. I can’t find an example. Help me ObiWan!

Topic

Access 97 Simple Question

In reply to Access 97 Simple Question

Assume that the first Form is named Form1Name and the field that is used on Form1 to display on Form2 is called FieldName. Create a new query to be used as the data source for Form2. In this Query set the criteria for FieldName to the following:
[Forms]![Form1Name]![FieldName]

Next, add a button to Form1 with a macro set to open Form2. That will cause the query to display the desired record in Form2.

Access 97 Simple Question

In reply to Access 97 Simple Question

Thank you for your help. I knew I was trying too hard!

[Author]

Replies