Search results

Ok - the issue has to do with me having the filter on load for the subforms set to yes. Turned it off and all is well.

Imported it back to the original database and it did not work. I'm attaching the sub database.

Well, shoot. When I exported the offending forms to a new database, it worked just fine. I'm at a lose.

I'll send you something ASAP

I have a form with 3 subforms that are linked by the one key field. The subfroms are located on a tabControl I open the main from from another form with a where clause. Only one of the 3 subforms displays the related data. The others are empty. If I change the view of the form to...

Got it to work. The data source for the form had 2 tables. I eliminated the other table and it worked. I'm not sure why, but this works for me. Thanks again for all the ideas.

I'll keep this as my fall back/work around!

Yeah, I thought of that. The limitation is that I use this entry form from many other forms. I could fire that code only if the specific form is open. Rather just get the NotInList event to work.

That works. However, the user then has to manually type in the new record into the entry form. Is there a way that I could get the NewData to automatically populate the corresponding control in the entry form?

OK, let me try that one.

Yes, however, I need to add additional data to the record - such as e-mail, phone number, etc.

I'm not able to get this Not In List event to function on this form. The event opens another form to add the data to the table that supplies the values to the combo box. The data is entered into the table. However, the combo box does not immediately show the new value and I get the...

OK, with help from a co-worker, we got the export of the long text field to work. With doc .FormFields("txtProject").Result = Me.[Project Name] .FormFields("txtContractNumber").Result = Me.Contract_Number .FormFields("txtPreparedBy").Result = Me.[Prepared By]...

Yeah, I see I did send the incorrect word document. Sorry about that. Here is the correct one as well as a video showing how to get the bookmark names.

Thanks! I really appreciate all the help you've given me on here!

Here is a copy of the database and the Word template. The offending text box is on top of page 5. The data base is a "work in progress" as is the word document. The file path for the word template will need to be changed on the form to match your saved location.

Can do. Give me a couple of minutes.

I have code that will export data on an Access form to a Word template with text box fields. All data exports fine, except a long text field. The Word text box remains blank. The Word text box is "txtPDescription" and the Access field is "ProjectDescription". I've tried a number of...

I'd like it to be able to run from any form - or subform.

Having trouble with this issue. I'm using code borrowed from somewhere else. I want the code to be independent of the from I am originating the event from. The original code was driven by an event on a main form. My issue is how to get the code to recognize the name of the subform. I...