S
Steve
I have a form FrmAircraftParts sending entries to Tbl of same name, with a
subform in it visible top right FrmForAircraftType sending entries to Tbl of
same name . I can use Filter By Form on the main form and get a result, e.g.
if I use a text entry window for SUBJECT and type "*tyres*" and hit the
apply filter button I see all tyres, and as I go through the results on the
main form, the subform shows me the aircraft they are for.
To show all records for an aircraft type I went Filter By Form and in the
FirstAircraftType window typed *Spitfire*, but hitting Apply Filter button
returns all 700 records, not just parts for Spitfire.
What am I doing wrong ?
Relationship window has it set up to one to many with the one being the
TblAircraftParts and the many the TblAircraftType , related on ID for part
(primary key for Parts table) which seems sensible.
Furthermore...
My data entry also uses tickboxes, I am unable to filter by form just on a
tickbox, ticking e.g. TOOLS and applying filter gives nothing, I can only
use a tick box in conjunction with a text entry box. so tick tools and type
*tyres* in subject window gives me tools for tyres. Is it impossible to use
just tickboxes in filter by form ? How can I see all tools records ? How
does one return just records where a tickbox is ticked ?
Steve
subform in it visible top right FrmForAircraftType sending entries to Tbl of
same name . I can use Filter By Form on the main form and get a result, e.g.
if I use a text entry window for SUBJECT and type "*tyres*" and hit the
apply filter button I see all tyres, and as I go through the results on the
main form, the subform shows me the aircraft they are for.
To show all records for an aircraft type I went Filter By Form and in the
FirstAircraftType window typed *Spitfire*, but hitting Apply Filter button
returns all 700 records, not just parts for Spitfire.
What am I doing wrong ?
Relationship window has it set up to one to many with the one being the
TblAircraftParts and the many the TblAircraftType , related on ID for part
(primary key for Parts table) which seems sensible.
Furthermore...
My data entry also uses tickboxes, I am unable to filter by form just on a
tickbox, ticking e.g. TOOLS and applying filter gives nothing, I can only
use a tick box in conjunction with a text entry box. so tick tools and type
*tyres* in subject window gives me tools for tyres. Is it impossible to use
just tickboxes in filter by form ? How can I see all tools records ? How
does one return just records where a tickbox is ticked ?
Steve