"Show" field in Query Design

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...
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Field dissapears from query when "Show" is unchecked 3
auto number in query 1
VBA: How can I use a string variable as autofilter criteria? 4
Query Criteria in a Form 0
Make table query only runs from design view. 3
MS Access problem 0
Access VBA error "Microsoft Access can't find the field '|' referred to in your experssion" 0

Top