Use results of a query to open corresponding records on the main form?

[altesse33]

Hi,

I have put together a reference library of journal articles and other citations. There are various queries that prompt the user to enter a search term (such as a keyword) and return all article citations that contain the keyword that the user entered.

We want to add a feature where the user could click on any part of the citation info returned from the query, and be taken to that same citation's record in the main form (frmCite).

I played around with this by having the results of the query displayed in a form, and creating a command button with an OnClick event. However, I haven't been able to come up with any VBA code that tells Access to open frmCite, go the record with the same CiteID (PK of tblCite) as the CiteID of the record in the query, and to do this for each record that is returned as a hit from the query.

FYI, here is the SQL statement that the query is based on:
SELECT tblCite.CiteID, tblCite.Title, tblCite.Journal , tblCite.VolumeN um, tblCite.IssueNu m, tblCite.Copyrig htYear, tblCite.BookTit le, tblCite.Publish erName, tblCite.Abstrac t
FROM tblCite
WHERE (((tblCite.Abst ract) Like "*" & [Enter search term] & "*"));

Does anyone have any suggestions? I know very little about VBA so the more actual code someone could help me with, the better!

Thanks in advance.

[altesse33]

Bump.

Please help me out, if you can. :(