Reply to thread

Message: [QUOTE="Larry Daugherty, post: 761674"] The best way to do it depends on where you start. ...If you have a lot of named queries I recommend that you take notes of what you've done so that you can recover if necessary. Failing that, make a backup copy of your application before you start. Assuming you don't already have a named query, base your form design on the underlying main table. Open the form properties and click on the data tab. Click the ellipsis (...) to the right of the Record Source text box. You'll be warned that you are about to create a query based on the table. OK. That opens the QBE grid. Design your query. Do NOT click the disk icon to save the query. Click the X. You'll be asked if you want to save changes to the query and update the property. Answer YES. You now have the query on which the form is based contained within the form. Assuming you already have a named query in the Database|Query window; Get to the QBE grid as above. Change to SQL view. Select the entire SQL statement and press CRTL-C to copy it to the clipboard. Escape or X your way back out to the form's Data properties and in the Record Source property, delete the named query. Click on the elipsis and when the QBE grid opens change to SQL view. Press CTRL-V to paste in the saved SQL statement. You can change to grid view if you wish. Do NOT save to disk! X out and answer YES to the question "Save changes and update the property"? You'll be back at the form's data properties and you'll notice that the Record Source now reads "Select ..." That leaves a named query in the Database|Query window. If you are sure that no other functionality depended on that query you can delete it. hth [/QUOTE]

Verification