Search results

Hello guys, thankyou for your quick responses, you are both correct and have helped me to solve my problem. I needed that additional code. Here is the code that works now: Private Sub Command10_Click() Select Case Me!Frame19 Case 1 DoCmd.OpenReport "rptIssSummary", acViewReport...

Hey guys, thankyou for your quick responses, you are both right, I have changed the code and it now opens the reports I want, not print them. Here is the code after the ammendments

I have attached a copy of the database if that helps

Hey guys I have 2 radio buttons and a button on a form. If the user clicks on one radio button and clicks on the form's button it opens one report and when the user clicks on the 2nd radio button and clicks on the form's button, it opens the second report. However what really does happen is...

Hey guys I now understand what you guys meant by an option group and thus the problem is solved. I appreciate your help and without you both I wouldnt have solved the problem :) Geore

Hello Jr, thankyou for your response. I know this may be a it of a silly question but how could I get the NameOfOptionGroup, each radio button has a separate name :confused: Thank you again for your response George

Hey guys, unfortunately my vba knowledge is very limited right now.... I have a form with 2 option buttons and a button. If option1 button is clicked on and the form button is clicked the form opened is cars2. If the option2 button is clicked and the form button is clicked, the form cars 3...

Hey guys, I finally managed for figure it out. The Search Form -I set the record source to the table with the data I wanted to retrieve -The textbox where the user enters the record number is set to unbound What happens is the user enters the number into the textbox and clicks on the search...

Thanks again for your response I know its going to pay off soon, yes thats exactly what I want to do. Enter a number in a textbox, click on search and the record is retrieved into the below textboxes

Hey Gemma, thanks for your response, it doesnt really as the form only has textboxes and a button, by using the ctrl + f function, it wont find anything as there is no data in the form for it to find

Hello John, thanks for the welcome, I will take a look and get back to you guys :)

searching for records with use of forms Hey guys, After browsing the internet for a while in search of a solution and flicking through numerous books, I thought you guys would be my best bet. The situation is I have a form with a textbox and a search button. The user enters an integer into...