Switching between form and list view

[iazcac]

Hi

I am trying to recreate a feature from Lotus Approach into Access.

In Approach, you can search for records, and the results are returned in the form view (like using ctrl-F in Access). However, in addition, you can then press a tab at the top of the form to show the results of the 'find' in a list view.

This also works vice-versa... once in the list view, clicking on a specific record will show it in form view

Any idea of how to do this, or something similar in Access. Am completely stumped!

Thanks

Chris

*Hope that is clear, as is quite hard to explain!

 

[Pat Hartman]

I would display the results in a datasheet view form. Then add a double-click event to one of the columns that opens a form for the selected record in single record view.

 

[mohammadagul]

As Pat Said make a Datasheet view form and then place a button to open the specified record. Or you can also do the following

1. create a continuous form
2. place a textbox name "Search" on the header
3. the control source of this form should be query.
4. in that query place this ciriteria for the field you want to search with
L:ike & "*"[Forms]![YourFormName]![Search]"*"&
5. on the afterupdate even of you search textbox place the following
me. form.requery

this would requery the form for each result shown. the same above code should be used in all the ciriterias you want to search with. just put the code one step below the previous criteria.

 

[iazcac]

Thanks for your replies, however, I am quite new to Access.

How do you add a double click event to a column?

 

[Pat Hartman]

Click on the control to which you would like to add a double-click event.
Open the properties dialog.
On the Events tab, scroll to the double-click event and click on the builder button (all the way to the right of the field - it won't be visible until you move the mouse over it).
Choose code if the module window doesn't open automatically.

Access should create a sub header and footer for the double-click event and place the insertion point inside the code module. Write your code here.

This is slightly easier if you add a button to the form. The button has a wizard that will guide you through the process. Read the options carefully. If the button doesn't work, just delete it and go through the process again until you get the options right.