E
Eric
I have a form called Lookup. I'm tring to allow the user to select via combo
boxes, fields that already reside in the table. I have 5 dropdown boxes to
choose from ( Year, Catagory, Leader, Initials, ID). I would like to put a
subform below the selection boxes that will change as the user selects the
"Known" data using the combo boxes.
The Selection combo boxes will start out being blank. The user selects what
he knows about the record (maybe not in any particular order). As he selects
.... say the Year: The read only subform displays the records (one at a time)
based on the Year selected. If he chooses another field such as Catagory,
then the subform would show records (one at a time) that have both the year
and the catagory as matches.
I was hoping to keep the Navigation bar set to yes: If the user selects
only the year, he/she could then arrow through the records until they find
the record wanted.
Once the record is identified, I want to put a command button "Select this
Record" that would pull the form to edit the Record selected.
I understand that some text boxes will be unbound and the text boxes on the
subform display will be bound. I also know that the command button will use
the "Where" statement referencing the bound text boxes to pull the form etc.
I hope this isn't to much to ask, I've looked in several differant places
but hav'ent found, or don't understand what others have presented.
Thanks for any comments/ideas
boxes, fields that already reside in the table. I have 5 dropdown boxes to
choose from ( Year, Catagory, Leader, Initials, ID). I would like to put a
subform below the selection boxes that will change as the user selects the
"Known" data using the combo boxes.
The Selection combo boxes will start out being blank. The user selects what
he knows about the record (maybe not in any particular order). As he selects
.... say the Year: The read only subform displays the records (one at a time)
based on the Year selected. If he chooses another field such as Catagory,
then the subform would show records (one at a time) that have both the year
and the catagory as matches.
I was hoping to keep the Navigation bar set to yes: If the user selects
only the year, he/she could then arrow through the records until they find
the record wanted.
Once the record is identified, I want to put a command button "Select this
Record" that would pull the form to edit the Record selected.
I understand that some text boxes will be unbound and the text boxes on the
subform display will be bound. I also know that the command button will use
the "Where" statement referencing the bound text boxes to pull the form etc.
I hope this isn't to much to ask, I've looked in several differant places
but hav'ent found, or don't understand what others have presented.
Thanks for any comments/ideas