Search results

UncleJoe, I appreciate what you're saying but all I want to do is copy the values from the previous record into a new one from within the same form. I do not want to copy values from the parent form to the subform. As I've said, if I configure the AutoFillNewRecords for the Transactions form...

Hi Shane, Once again thank you for your help and patience. Yes, Products is the main form and Transactions is one of the subforms. If this helps, within the main Products form there are three subforms including Transactions. The default value is defined as you say on the control in the...

Anyone? please? :o

Shaneman, It still is not working. I've tried different syntax variations for the default value, the last one being [Forms]![frmProducts]![frmTransactions]![Size1Amt]. Please suggest something else! :) Tony

Hey ShaneMan, Thanks for your answer. I tried it and I'm no longer getting the "type mismatch" error. However, it is not autofilling! Could it be that defined fields to autofill need to be referenced differently? Thanks again for your help. Tony

Moniker, Thank you for responding. I'm just trying to use the AutoFillNewRecord function in a subform from the main form. If I just open the subform, it works! If I access the subform from within the main form, it doesn't. I'm not transferring information from one form to another. Tony

I'm using Microsoft's AutoFillNewRecord function found here http://support.microsoft.com/kb/210236 that you may already be familiar with. The problem is that I get a type mismatch error when using it with sub forms. My main form is "Products" and I want it to use the function within a subform...

Hi Wayne, Prior to adding the DoCmd.OpenForm line, it worked as it should. However, now I've added an archive table/form, and I want it to display the record of the archived information - not the current form. This is why I've added the DoCmd.OpenForm line. Are you saying I should remove the...

Hello all, Here's what I'm trying to do: If a value exists after input, display the message that it already exists in the "archived" version and then open the form of the archived table and display the record of the existing value. Here's the code I'm using: Private Sub...

Hello, I Have a simple database that combines three tables (Style, Fabric, Products) that are linked with referential integrity relationships. The issue is when I change, for example, a cost value in a Fabric field and it changes all the associated records in Products with that corresponding...

Anyone out there that can help on this? I'm stuck! :(

Thank you PeteHillJnr for your reply - appreciate it. I've tried your code but I get the following message: Run-time error "2465' MS Access can't find the field "|" referred to in your expression. Which is weird because there is no "|" anywhere near this code! When I click on the "Debug"...

Hello All, I'm using the code below to verify if a Product Number has already been entered into the form. Private Sub ProductID_BeforeUpdate(Cancel As Integer) Dim varX As Variant varX = DLookup("[ProductID]", "tblProducts", "[ProductID] = '" & Forms!frmProducts.[ProductID] & "'") If Not...

Almost forgot! Thank you DennisK also! :) Tony

Spot on Bob! I like to prefix my forms with "frm" and I just checked the control name of the subform of the main form and, as you said, the name is different - no prefix! I corrected it and it works. Thank you very much Bob and Lagbolt for your help. Much appreciated, Tony

Lagbolt, Are you kidding? I may not be an Access expert but this much I know. :) Regards, Tony

Thanks for responding. I keep getting the message "Form not found" when trying any qualifying name! :confused:

Hi, I have a "products" main form that contains three subforms. The first subform displays "opening inventory" information and the second subform displays "transactions". The third and last subform displays a running total of additions and subtractions from records in the first two forms...

It worked! Thanks RG! :) I need to review syntax! Regards, Tony

Here's the complete sub: Private Sub cmdPrintRecord_Click() On Error GoTo Err_cmdPrintRecord_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Dim strDocName As String Dim strWhere As String strDocName = "rptProducts" strWhere =...