Form using a list box to filter with a subform connected

[Guest]

Please can someone help me please
I am running a filter in a form by using a query showing employee name I
then wish to filter from another query filtered information from that person
... It works great but it is continously adding a new entry into my employee
table. I know this to be because i am allowing the additions , add entry and
edits to be shown as yesy but if i put no i lose the ability to filter on my
name and the screen goes blank if i say no additions.
hope you understood all that
Thankyou

 

[Guest]

Another thing that would cause that is assigning a value to a bound control.
Look for something like text1.value = "Some text or number" and it would be
in some event like On Open or On Current. If it filters for and finds
nothing then those lines will cause a new record to be created.

Hope this helps.
Good Luck!

 

[Guest]

Hello visdev1,
I have looked at my events and controls and there is nothing that seems to
be causing this to happen ?