Search form makes new record with results.

[mbhw99]

For Access '02.

I have a report that does this perfectly (except making the new record). This is the query sql:

SELECT TOP 10 PERCENT [all locations].AutoID, [all locations].Location, [all locations].Zone, [Zone Code List].Building, Rnd([AutoID]) AS RandomValue
FROM [Zone Code List] INNER JOIN [all locations] ON [Zone Code List].[Zone Code] = [all locations].Zone
WHERE ((([all locations].Zone) Like [Enter Zone #:]))
ORDER BY Rnd([AutoID]) DESC;

What I'm getting stumped at:

I want what happens in the report to happen in the form with the results to make a new record. This record can be brought up on another form (yet to be made) for more data entry on those results.

My raw data comes from table "all locations". The field I want to search is "Zone". The results of the search will populate the forum with field "Location".

I've tried subforms and I'm just ending up :banghead:.

Any help would be greatly appreciated.

 

[mbhw99]

or...

is there a way for the query from the report to make a new record and bypass the form?