Search results

I have a main form which displays data and the textbox from which users can type a keyword as a query. when the query is run, a datasheet is opened with the query results. since the main form already has all the fields, i want my query to display the results exactly in the same form where is...

Thanks a lot for your replies. the problem was due to the table relationships. i have another problem though. how do i display the results of my query in the same form that i run the query from. the query returns a datasheet, which i think is the norm. Thanks!

it does not give me any error nor ask me for any value. its just that i dont get any results. it just gives me a blank datasheet with headers but no data. the query should have returned lots of records with the keyword i typed in. should i assign a variable for the text box?

I cant seem to make a text box as a source of my query. in the criteria, i entered forms![forms1]![textbox1]. am i missing something?

thanks a lot! i will follow your advice including naming controls.... thanks again!

i am able to grey out(disable) a command button when textbox1 is empty. but how can i enable the command button once a user enters info in textbox1? this is the code i use: Private Sub Form_Current() If IsNull(Me.Text25) Then Command27.Enabled = False Else Command27.Enabled = True End If...

I am a newbie, so can you please tell me how go about what you advised?

I have a query that prompts users for a parameter. the results of the query is outputted to a form. on this form, i have a command button to preview a report based on this query. the problem is whenever i run the report, the same dialog box prompts me for the parameter. how can i get rid of this...

I have a query that prompts users for a parameter. the results of the query is outputted to a form. on this form, i have a command button to preview a report based on this query. the problem is whenever i run the report, the same dialog box prompts me for the parameter. how can i get rid of...