General discussion

Locked

Access 97 Simple Question

By 4608315 ·
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!

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 97 Simple Question

by Larry H. 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.

Collapse -

Access 97 Simple Question

by 4608315 In reply to Access 97 Simple Question

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

Back to Windows Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums