Creating a searchable combo box

[laht0028]

Hello,

I am attempting to create a form with a combo box that searches a subform and I have been using the following link as a guide (https://www.youtube.com/watch?v=8N1hRBd sI1s). When I set up the subform to contain fields from several different relational tables I am unable to see the populated records in the Layout view. If I use one of the tables (which contain only numbers for the foreign keys that I do not want users to search on) then I am able to visualize the populated records. Any thoughts would be greatly appreciated!

[laht0028]

I'm finding that if I have all the fields filled out then the records appear in the subform. If one of the fields from one of the tables is not filled out then the subform will not show that "incomplete ly" filled out record. I don't care if all the information is not there. I want to be able to see any available record information. Thank you again for your assistance!

[hvsummer]

another long step toward form making...
I have spent 30hours to learn how to create form from internet
you can do that too.
I'll give you some advice.
-first you have to know what is source control, what is row source of combobox. different between them.
-then you need to know all usefull property of those box (listbox, combobox, textbox). for example (listbox and comboxbox have these control-property you gonna use much: "control'sname. itemselected,
.itemselected.c ount, *box.enabled, *box.requery)
-then learn to put the Forms!nameoffor m!nameofcontrol/box inside the criteria of query's control of form's object (listbox, combobox)
-try to test and fail, it'll give you experience.
-learn the event of form: afterupdate, click, focus... etc.
-learn the VBA code for form. (not much)
-learn how to bound control of child field and master field link between subform and mainform.
then you'll able to create your own form.

[NeoPa]

Some good advice there.

HVSummer:
-then learn to put the Forms!nameoffor m!nameofcontrol/box inside the criteria of query's control of form's object (listbox, combobox)

This one line I'd take with a pinch of salt (That means be careful of it). I don't advise using that approach where you can avoid it as it ties queries to specific forms and thus makes them inflexible. Forms have filter properties which, if used, allow filtering to be specified for the form without requiring a new query be created for each form.

HVSummer:
-try to test and fail, it'll give you experience.

Absolutely true. Very good advice.

Most of the rest is good too, but that line particularly so.

[jforbes]

I won't go to youtube unless I have to. There are plenty of reasons, but the biggest and most important here is that if you would like us to help you with your code, you can post the code here and then we will all be on the same page and commenting on the same code, specifically, your code.

Regardless if you post your code here, this might be beneficial to you in your situation: http://bytes.com/topic/access/insigh...filtering-form