Hey all,
Is there any way to prevent fields from opening in a recordset field list without actually removing the field from the recordset?

Basically, I've created a customer search window for my database app. The search window can be opened from any other window in the app and simply passed an ADO RS. From there it will show all fields, allow the user to search on all fields, etc. The problem is that I cannot find any other way to pass the selected result back to the owner window without using a bookmark, which I don't have a problem doing. The only problem with using a bookmark is that the recordset passed to the search window must either be the same or a clone of the recordset I'm using in the owner window. Obviously, there are some fields that the user will have no idea about - such as primary key values or other such values. I'd like to somehow hide these fields from the user so that they're not displayed.

When the search form opens the collection of fields to use is derived directly from the recordset passed to it. The only idea that I can think of is to have the user populate the field collection before the form is shown. The end goal of the search form though is to make things automatic - how automatic is it if there needs to be a 50 line sub to initialize it..