Originally Posted by
ItsMe
I am having a hard time following. You have a new form open so that you can add a new record? Then you would want to open your form to open and show only a new record.
It is confusing when you state that you want a data entry form and also display relative records.
Perhaps you should work on creating a Main form with a subform and get your Master/Child Link fields set up correctly. Maybe use the wizard. Afterwards, you could create an unbound combo to "Filter" the Main form. The combo would really work independently from your main form. The combo would act as a way to get user input. It would not be bound and would not update data in your tables. You would simply use the value of the combo to apply a Filter to the form.