Discussion Locked

Access 97 Simple Question

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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!

2 replies

by larry h.

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.

by Former member

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

This discussion is closed to new replies.