Search results

Check the link below to make sure you are referencing the combo box in the subform correctly. If you are then you should be able to requery the combo by redefining the Row Source property. http://support.microsoft.com/kb/209099 Forms![ParentForm]![ChildForm].Form![ComboBox].RowSource =...

Since you only have 3 values, you could try nested IIF statements as a field in the query for the report, something like: IIF([FieldName]="L", 100, IIF([FieldName]="M",175,IIF([FieldName]="H",250,0))) If the list of values could grow, you may want to have a seperate table containing the...

As long as [Primary No] is on the main form you can use: stLinkCriteria = "[Project No]='" & Me![Project No] & "'"

If [Project No] is actually a number field, then Tanya's solution should work. If it is a text field then you will need the code: stLinkCriteria = "[Project No]='" & Me![Main Project Data].Form![Project No] & "'"

Assuming you are using a form, then you can code the On_Click event of the checkbox related to the Refund Required field. Do a test to see if the check box is yes or no and then set the refund amount accordingly. Private Sub chkRefundRequired_Click() If Me.chkRefundRequired = -1 Then...

You need to add AND into you WHERE clause in the Docmd.OpenReport method to make a valid querystring. DoCmd.OpenReport "AgentDetailReport2", acViewPreview, , "[LastName]='" & Me.Combo38 & "' AND [date] Between #" & Me.cboFrom & "# And #" & Me.cboTo & "#" As John Big Booty suggested, it is...

You can use the WHERE clause parameter on the Docmd.OpenForm method to select the correct record in your details form. This assumes the details form is data bound and that there is field on the parent form that contains the primary key - usually an invisible textbox. Also, it's not a bad idea...