Split form in Access2000 ?

[Ally1205]

I saw a video of Access 2010, showing the split form feature: a form with two sections: the top half was like a single-record form, on which you could place text boxes, combo boxes, command buttons, etc. The bottom half of the form looked like a table, showing multiple records (one per row). If you clicked on one row of the bottom section, that record would appear in the top half of the form as the current record.

Is there a way to do this in Access 2000? I would really like to emulate a search tool, constructed in A2010, using A2000.


This video shows it: http://www.youtube.com/watch?v=wCPs4aE5I2w

Many thanks,
Ally1205

[pbaldy]

It wouldn't be hard to duplicate, with a form/subform. You'd use the current event of the subform to either reset the record source of the main form, or move it to the appropriate record with a bookmark. The bookmark method would look like this, minus the opening of the second form:

http://www.baldyweb.com/Bookmark.htm

[Ally1205]

Paul, Thanks, I have simply put a subform on my main form. However, here I need help: I want the subform to display the results of a query. The query is run by typing in search strings into any of three textboxes in the top half of the form, which also displays fields from the current selected record. I want to be able to click any of the records showing in the subform so that selected record becomes the current record showing in the top half of the form. I have a "run query" button next to the thee textboxes. When I type something into any of the textboxes and hit the run query button, I want the records showing in the subform to change according to the search results. At the moment, when I hit the "run query button", it just opens the query in another window. How do I get the query results to show in the subform instead? The query results show when I first open the form, (showing all records, because I haven't yet entered anything into the search string entry boxes. They don't change when I run the query after entering search strings onto one of the three textboxes.
Ally1205

[June7]

Don't 'run query', instead refresh/requery the form by clicking Refresh from menu or running code. This thread essentially a duplicate of https://www.accessforums.net/forms/l...one-40144.html