Search Form help on a Search form

[Ydrasil72683]

Hello
I am new to Access, but I am currently working on a small database in one of the local college to keep track of all the lockers in the building. Now the way it works is the user will enter the search criteria data into a form, then that data is sent to the query which searches for said data in the table and displays it in the query.

Now to get the data from the form to the query I am using Like Forms!Lock_DES_Frm!BLetter&* (I am putting this into the criteria section of the query in design view)to take the input from the from. Now Lock_DES_FRM is the name of my form and BLetter is the name of the first field. All the textbox's on the fields are set to null.

Now the problem I am having is this code works for the first 3 fields but doesn't work when I put it in any of the other fields( I have done seperate testing with individual fields past the first 3, and they still don't work individually). I don't get a error it just displays a blank table, but there is data in those fields, cause I put it there. Is there any reason this code would cause the table to appear blank ? Thank you for any and all help.

 

[GinaWhipp]

Are you filtering on filtered data? That would be my guess. You might try writing something to clear the filter before running another... So on your Command Button...

Me.Filter = ""
'Run your filter here

 

[Ydrasil72683]

sorry about my late reply but know I am not running any filters and on my command button I put:

Private Sub Command35_Click()
Me.Filter = ""
DoCmd.OpenQuery "Q_Lock_search", acViewNormal
End Sub

Unforunately this still gives me a blank table, so if its not a filter what else could it be ?

 

[jdraw]

Please show us the code for the Q_Lock_search query.

 

[Ydrasil72683]

You will have to to forgive my lack of understanding, but is the the code in SQL veiw what you are looking for ? if not where do I look to see the code you are looking for the query ? and I did attempt to post my code from the SQL veiw but apparently the forum considers it a email address for soem reason, and it wont let me post

 

[GinaWhipp]

You should just be able to copy/paste... What happens when you do that?

 

[John Big Booty]

The sample here may provide you with some additional ideas.

 

[Ydrasil72683]

Ty for the advice john sorry getting back to you so late, got caught up in work.To answer the question Gina I do try and copy/paste to the forum but I get the above mentioned error,but I was wondering if anybody would know of a sample I can look at to append data in a table using a form ?