Search results for query: *

Thank you for the help. The solution incorporated the advice from both GingerR and lameid. I made a table that outlined the order I wanted for the Test values called QC Index. Then I placed this code in the record source for the form. SELECT [QC Results].LabNotebook, [QC Results].Test, [QC...

I want to specify a custom order for a sub continuous form. I tried an IIF statement like IIF([Test] Like "Viscosity", 1, IIF([Test] Like "Viscosity 0hr", 2, 3)) in the Order by property of the sub form. The Form basically ignores the statement. Also is there a way to force the form to order...

Thank you for your help. I believe I have solved the problem. I added a macro that uses Runcommand to Saverecord. I put this macro on the controls in the After Update field for which I want to immediately update. So far this is giving me the results that I wanted to see. I need certain...

I opened the form in design view. I opened the properties for the control and wrote me.refresh in the box for After Update. I switched back to form view and inputted a name for a formulation. When I tabbed to the next control it gave the following error, Microsoft Office Access can't find the...

A main form is used to enter data for glue formulations. I create a new record and enter the name for the formulation in the specified control. This data will not show up in the underlying table unless I switch records or click on a sub-form. I feel that I need some kind of code in an event...