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!

 

[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?