Search results

Okay, that answers my question - thanks.

If this is the exact code you are using, then you have one too many commas before stLinkCriteria in the highlighted line of code. It should be ... DoCmd.OpenForm stDocName, , , stLinkCriteria

Actually, this msgbox is set up with a Case Statement. I have an If before it and Case statements afterward. I just included a snippet of it here to illustrate for Dave that I don't need to "... require constants such as 16, 32, 48 or 64 to obtain critical, information, etc icons on the...

As an example, I use this to verify information before a complete autofill on a form. It could use the vbInformation, or vbCritical, or vbExclamation and all would (and have) included the appropriate icon on the msgbox. I'm not sure I follow.

And vbQuestion for the question mark in the baloon.

You're welcome. Now you can tweak it using CEH's code and see if you can get it to print from within the program instead of right-clicking in preview mode.

That's the correct code to do what you described. It will open up the form and go to a new (Blank) record. Are you putting this code on the ONCLICK event for the command button that calls it?

That's pretty slick code. I have a use for that in something I'm working on. :)

Fixed. Now it will preview the current record. You had the PK control named wrong. You had named it as the command button and it should have been named ID (the name of the control in the form).

This will open a preview of the current record in the report you specified in the code. You can then right mouse click and choose Print. From there you can set up the printing in any manner you like.

Check your personal e-mail :)

Glad to hear that you have it under control now. If you need some help with the report side, ask the question intelligently, let the board know what you have done already to resolve it, and chances are excellent that you will get a response. :)

I'm glad to hear that you got it working. An answer to your question for future use - you could inner join the tables then use nearly the same WHERE statement to pull the data after that.

That's true Bob, the great rule of referencing forms.subform.subform of subform :)

Are you using ... Me.YourSubformName.Requery That should put the data in the subform on the form.

Private Sub Report_Open(Cancel As Integer) On Error Resume Next Set frm = Forms!YourFormName If Err.Number = 0 Then With frm If !YourComboBoxName = "YourSelectionName1" Then Me.RecordSource = "Query1" ElseIf !YourComboBoxName =...

You can requery the control on the AfterUpdate Event ... Me.MyControlName.requery

Me.refresh

Record Selectors NO in the format properties for the form.

SELECT YourTable.* FROM YourTable WHERE (([TableField1]=Forms!YourFormName!ControlName Or Forms!YourFormName!ControlName Is Null)=True) And (([TableField2]=Forms!YourFormName!ControlName2 Or Forms!YourFormName!ControlName2 Is Null)=True) And Keep going to include all of the controls that you...