Continuous form to single record view - advice?

[SprayCan]

Hi everyone,

I've got an issue with the search facility of an Access database. The existing search facility for the database in question is simply a combo box that displays two columns of data from a table, and then displays the relevant record when a row is clicked.

I've decided to upgrade this search facility. What I have in mind is an initial continuous form displaying all records that are relevant to the search criteria. From here, users will click a button (repeated for each record)and a new form (in single record view) will open up showing them the complete record data.

This search method is already in use for another database here, so I know this method works. Only problem is I don't have access to the back-end MDB (can only view an MDE), although I'm almost definate something like this would need to be coded in VB.

Can anyone help me out with this? I'm a VBA newbie, and prefer to work backwards (see the end result, figure out what everything does so I can emulate).

Thanks if you can

 

[Zion7]

Look into the wizard for the command button,
...Forms => Open...

 

[SprayCan]

Well stone the crows didn't notice that lil feature, thanks