help : error2101

[amerhendy]

my form is for search
i have 2 option (sader , wared)
there is subform called result
there is 2 queries called "fr_wa , fr_sa"
when i choose wared , there is error appeared called "run time error '2101'"
and too when i choose sader
the code is :

Private Sub wared_GotFocus()
[creators_text].Visible = True
[a1].Visible = True
creators_text.Caption = "converts"
[from_text].Visible = True
[a2].Visible = True
from_text.Caption = "convert to"
sader1_text.Caption = "convert result"
result.SourceObject = "fr_wa"
End Sub

[ItsMe]

What happens if you comment out the following?
result.SourceObject = "fr_wa"

[amerhendy]

What happens if you comment out the following?
result.SourceObject = "fr_wa"

the same error

[ItsMe]

The only other thing I can imagine is you are changing a property that can not happen on the Got focus. The only other one that stands out is

from_text.Caption = "convert to"

If, when the error occurs, you choose to debug, what line of code gets highlighted? you may need to use a different event handler.

[amerhendy]

really thank you
i make form instead of the query
it done
thank you
but i dont know why i show the records twice in the query or in the form ( it is only one in the table)????

[June7]

Does the query include several tables? Do they have a 1-to-many relationship?

Post the sql statement of the query.

[amerhendy]

SELECT wared.w_id, wared.w_came, wared.w_topic, wared.w_goto_creators, wared.w_goto_creators_copy.Value, wared.w_files.FileData
FROM wared;

[June7]

If two records show in the form then there must be two records in table wared.

Why do you want to change Source Object?

If you want to provide db, follow instructions at bottom of my post.

[amerhendy]

If two records show in the form then there must be two records in table wared.

Why do you want to change Source Object?

If you want to provide db, follow instructions at bottom of my post.

thanks you
but there is 6 records in table wared ..... but in the form its 12 records
i want to change object because i need search form with 2 tables and 4 choice
thanks you

[June7]

Sorry, that doesn't help me understand the issue.

[amerhendy]

If two records show in the form then there must be two records in table wared.
there is 6 records in the table ... the query form show 12 records

[June7]

I still can't figure out what is happening. Will have to view table, query, form.

[trevor40]

if you are using a query, it sounds like you added them to the query window but failed to join them correctly. giving multiple results for each table list.