Results 1 to 2 of 2

Thread: Help creating a search form

  1. #1
    Join Date
    Sep 2014
    Posts
    1

    Help creating a search form

    Hello all,

    I need help creating a search form. I have no knowledge of SQL and I've looked at many examples and can't seem to figure this out. I've attached the database and hopefully someone can give me some help with the SQL code to create this search form. I created the layout of how I want to the search form to look like and it is saved as "ReadingSearchForm". It has 5 multi-select list boxes and 4 combo boxes. I want the user to select the criteria from the list boxes and combo boxes and the information will appear in a subform.

    If anybody could help me that would be great!

    Example.zip

  2. #2
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    275
    I will help you but your database needs to be normalized.

    Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency. Have look at this link http://support.microsoft.com/kb/283878

    Is there a special reason why you are using a combination of combo boxes and list boxes?
    Allan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •