Recent content by keviny04

The OP probably didn't like MVF and wanted to switch. I've found MVF to be most useful when I need a "choose all that apply" type of user input. A MVF is shown as a drop-down list of checkboxes, which is easy for the user to operate and to understand its purpose. For instance, a search form...

When you are in subform2 and want to refer to subform1, you need to refer to the PARENT of subform1 also: If Me.AllocatedTotal > Parent!frmNetPurchasedInventory.Form!MaxPackagesAvail Then The parent of subform1 and 2 is your main form, PrepOrders. You can also refer to your main form by name...

The problem seems to have been fixed. I was also hit by this, and had to tweak my code that involved Recordset, like the posters did above. But note that this had nothing to do with Recordset nor our coding skills. All the errors in this little mishap had nothing to do with anything. It was...

I have a form set up as shown in the picture below. The subform on the left is bound to a local Access table. The subform on the right is bound to a local SQL Server 2014 Express table. Btw, this database serves no real-world purposes. It is specially made just for me to ask the following...

I believe to close a form you need: DoCmd.Close acForm, "FormName"