Search element

[mlthomas007 via AccessMonster.com]

Hi,

We have a current database that has a search form. When you selected the
search button on the form it pulled a second form with all our ID data and
demo info. Now when you select the search button it pulls the form but there
is no data in the form. I can not find out what broke down...

 

[Wayne-I-M]

What is the code behind the button (can you post it here)

Try opening the form (from the main view window) so that it is not filtered.
Does it show the data

Open the query the form is based on - is the data there

You need to give much more details about the problem (like answer to the
above) to get any type of answer that will help

 

[mlthomas007 via AccessMonster.com]

Hi,

Sorry pretty new to this. I just looked at the query and there is no data in
the query for this form. Also I did check to make sure it is not filtered.

Thanks Wayne.

M~

 

[Wayne-I-M]

Can you post the sql

Open the query in design view
select View
Select SQL
Copy all the "stuff" you see and post it here

This way we will be able to see (I hope) what the problem is

 

[mlthomas007 via AccessMonster.com]

SELECT Master.FamID, Master.FamInd, Master.IndID, Master.Last, Master.First,
Master.DOB, Master.Street, Master.City, Master.State, Master.Zip, Master.
Phone, Master.FamType, Master.Proband, Master.RelPro1, Master.Relation,
Master.Gender, Master.WPhone, Master.WPHoneOwner, Master.Adopted, Master.Race,
Master.Education, Master.Occupation, Master.User, Master.Comments, Master.
AddContact
FROM Master
WHERE (((Master.Last)=Forms!frmNewID!LAST))
ORDER BY Master.FamID, Master.FamInd, Master.IndID;

Would we need to add FamID to the WHERE statement as well? Since we want to
add that numeric value to the search?

Thanks Wayne. M.

Can you post the sql

Open the query in design view
select View
Select SQL
Copy all the "stuff" you see and post it here

This way we will be able to see (I hope) what the problem is

Hi,

[quoted text clipped - 21 lines]