D
DGregg
I'm using Access 2003 and am not a programmer or in a computer-related
industry so I do not understand VBA, although I do know Form basics. I'm
trying to create a form whereby users would enter criteria based on several
list boxes (do not need users to enter any criteria). Once all of the
criteria has been selected I would like to incorporate a select button that
would then go out and search for the criteria entered. Users will never have
to input any data, only retrieve data. I'm not sure how to go about setting
this up. Do I set up a form based on a series of queries or the table? I
have a table which contains the data so users just need to select their
search criteria.
The source data originally had multiple entries within one field (i.e. field
'premise type' contained multiple entries of 'house' and 'apartment'). I
designed my Access table to break this up so that I now have two separte
fields, for example, 'Premise-1' & 'Premise-2'. On my form I want to be able
to create one list box (i.e. Premise Type) in which the user will be able to
select multiple criteria (i.e. house, apartment, duplex), upon entering
'select' button, the criteria entered on the form to then search within the
Premise-1 & Premise-2 table fields (So, search records where Premise-1 or
Premise-2 contain either 'house' or 'apartment' or 'duplex'). I need to be
able to do this for multiple search criteria within the form. I would like
the results to appear on a report (I should be able to manage the report
part). Any help is greatly appreciated. Thanks in advance!
industry so I do not understand VBA, although I do know Form basics. I'm
trying to create a form whereby users would enter criteria based on several
list boxes (do not need users to enter any criteria). Once all of the
criteria has been selected I would like to incorporate a select button that
would then go out and search for the criteria entered. Users will never have
to input any data, only retrieve data. I'm not sure how to go about setting
this up. Do I set up a form based on a series of queries or the table? I
have a table which contains the data so users just need to select their
search criteria.
The source data originally had multiple entries within one field (i.e. field
'premise type' contained multiple entries of 'house' and 'apartment'). I
designed my Access table to break this up so that I now have two separte
fields, for example, 'Premise-1' & 'Premise-2'. On my form I want to be able
to create one list box (i.e. Premise Type) in which the user will be able to
select multiple criteria (i.e. house, apartment, duplex), upon entering
'select' button, the criteria entered on the form to then search within the
Premise-1 & Premise-2 table fields (So, search records where Premise-1 or
Premise-2 contain either 'house' or 'apartment' or 'duplex'). I need to be
able to do this for multiple search criteria within the form. I would like
the results to appear on a report (I should be able to manage the report
part). Any help is greatly appreciated. Thanks in advance!