Data Viewing

[TES]

I am looking for a way to display a list of all my records then form that
list filter for items in the fields. This would be bigger, but look like
filed one ID (key and auto number), field 2 type (GH, FH, or XK), filed 3
test (A, B, C, or D).
When opened the datasheet view would list everything, but the viewer could
filter for type GH only and further filter for test B. I would like the
datasheet view to open in a form when the ID field was clicked on.
Is this possible?
If so is it a sub table, or what?
If someone could point me to a link with help on this, I would be grateful.

 

[June7 via AccessMonster.com]

You are designing for other users and don't want to rely on menu/right click
data sorting and filtering but instead create controls? Use a subform or if
in Access2007 check out the new Split Form object. Have unbound controls on
main form where users enter or select from list info to base search on. Then
in Click event of a button have code that changes the RecordSource or Filter
property of the subform and Requeries the RecordSource or sets Filter.

Ex of subform recordset requery, note the reference to the subform container
name:
Me.ctrSampleList.Form.RecordSource = "SELECT Submit.* " & _
"FROM Submit WHERE LabNum = '" & Me.tbxLabNum & "' ORDER BY Submit.LabNum
DESC"
Me.ctrSampleList.Form.Requery

Ex of changing form filter:
rm.RequeryMe.FilterOn = False
Me.Filter = "LabNum='" & Me.cbxLabNum & "'"
Me.FilterOn = True

There is a click event for controls but then when users clicked into box or
clicked droplist, the event would trigger. Need code in event to handle (If
box is null then do nothing else open form).