Search results for query: *

Duane, A new form is not being opened. The parameter plugs into a query that allows only the records that meet the criteria to be shown. Parameter prompts are used with this database that performs a mail merge in word.

Good morning, I am having an issue with a Microsoft Access 2007 database that i recently created. I have created a button that invokes a parameter box which asks for user input to perform a search and retrieve only certain records. The database is split with a front end which is local on each...

I agree. The current text box is a bound control. I pull the paragraph title and that in turn populates the paragraph so that each record has it's own paragraphs associated with it. what I wanted to do was be able to make changes to the paragraph on the form for each record individually...

No Duane. Each record will have different paragraphs.

Duane, No, it is not a single record result from the query. lameid, I will try that.

Duane, That works perfectly and does what I need it to do. Just one other issue, For the query I use for mail merge it pulls the data from the table, not the form. Is there have a query pull data from a form instead? Below is my query SELECT tblnameaddress.firstname, tblnameaddress.lastname...

Duane, How will that be any different? Will it allow me to make edits to that paragraph? Won't it still be a bound control? Or is setting it equal to "me.txtparagraph" going to allow editing?

Duane, Being fairly new and teaching this to myself, I have not attempted to code it. If that is something that can be done, I am all ears. Thank you guys for any assistance. It is much appreciated.

Sure. I have a table with two fields, paratitle and paragraph. This table is linked to the front end of the database. The user when working on the form, clicks the drop down box of the paratitle and selects the paragraph title that corresponds to the paragraph they need to use. The drop down...

lameid, I already use a query for the mail merge. I am just going crazy trying to make that field that pulls the paragraph from a table, editable. Its a bound control, therefore it won't let me make an edit. And if I could edit the paragraph, I don't want it to alter the original paragraph on...

I have an Access 2007 database in which I have a combo box showing one column. The data from this column is linked to a table "tblparagraphs" with two fields, Title and Paragraph. When the user clicks on a title in the combo box, a separate text box fills in a corresponding paragraph. This...