Restrict data on a datasheet form

G

Grace

How can you restrict data that is displayed on a datasheet
form without putting the filter in the query that the form
is based on?

For example, I have a subform [subformhelpdesk1] that is
based on [QryHelpDesk]. I would like the subform to only
display records that do not have a [CallStatus]
of "Closed". I have another form that is based off this
same query that does not require the restriction. I did
create a new query for [subformhelpdesk1] that had the
criteria set to "Not Closed" but for some reson when I did
this my subform links got messed up!!

Thanks For your help.
 

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

DLookup in Continuous form 0
Creating a Chart on form from selected data in query. 0
Which is faster? 6
Filter Datasheet based on Combo Box selection 3
linking subforms 4
2nd Combo box does not change subform 4
Main \ Sub Form Data 1
Can't filter subform (in datasheet view) 3

Top