If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data Viewing
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. |
#2
|
|||
|
|||
Data Viewing
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). TES wrote: 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. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200908/1 |
Thread Tools | |
Display Modes | |
|
|