"Show" field in Query Design

  • Thread starter Thread starter Mike Janes
  • Start date Start date
M

Mike Janes

I would like to make a query, and then make that query into a form.
There's an auto-number field that I would like to hide in the query
results. When I uncheck the "show" field in the auto-number column and
save/close the query, the auto-number field is gone when I reopen the
query in design view.

The problem with this is, the query/form is a "masterlist" of all
personnel. I would like the have a command button which opens up
details on the selected record. I need to link the the "master" form
with the "details" form using this auto-number (hidden in both forms).
But when I hide the auto-number in the query, I can't do this.

Any sugestions? I hate having to "hide" a field in a form's design...
 
Well you just gotta hide it in the form and not in the query. You see if you
hide it in the query it is not part of the output and the form never sees it.
 
Back
Top