Beau- If you change the datatype of the column from text to number then you do not need single quotes around the value. Do this for text values DoCmd.OpenReport stDocName, acPreview, , "[Type Of Position] = '" & Me.cboZip & "'" This for numeric values DoCmd.OpenReport stDocName, acPreview, , "[Type Of Position] = " & Me.cboZip Tools->StartUp->Display Form/Page sets which form to display when the application opens, set it to none if you want nothing to happen. -Anthony -----Original Message----- From: Beau Thompson [ mailto:n9mfk@xxxxxxxxxxx] Sent: Wednesday, May 28, 2003 11:39 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: ExmplChangerecordset? hi Anthony thanks that worked There are 2 more things then I will have it down. Would any thing change if it was a field that was set for numbers and not a text box. Also is there a way to stop the query form from popping up everytime you start that data base. Thanks for all your help beau ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************