enter value message

[kes]

hi,

I have a question and I will try to simplify it as much as I can.

I have a form(form1) that the user is entering data into the table through it and another form(form2) that include a text box to select user and a query based table that shows the data accroding to the text box.

for some reson every time I open form1 I get enter value message for the text box in form2 (and it's not open!).

why is that???

I've added a picture of form2. hope it's help

 

[pbaldy]

It sounds like something in form 1 is referring to form 2. Check the record source and textbox control sources.

 

[kes]

Thats the thing! Nothing on form 1 is referring to 2....
The query on 2 is using the table that in form 1 but that's all...

 

[pbaldy]

Can you post the db here?

 

[kes]

added the file.

the problem is on screen 2 it's reference to form called Choose_project.

thanks for your help!

 

[kes]

I solved the problem. I used the same query on both form by accident!
thanks for the help!

 

[pbaldy]

Glad you found it!