Search results

aha! Thanks!

Is there an obvious (or not so obvious) way to get it out of error handling and work?

Thanks Bob, that worked.

I have a combobox (cboUser) that filters a listbox (lstCases). When the form opens, both are blank. A person selects their name from cbuUser and then lstCases shows just their cases. Then they click in lstCases so they can start typing which moves them down the list as needed. How can I move...

I have a button on a form (frmEmail) that opens a blank email in Outlook. I want it to close the form (frmEmail) sort of at the same time that the blank email opens. Can anyone tell me what I should do? Private Sub cmdSendEmail_Click() On Error GoTo Err_cmdSendEmail_Click Dim stDocName...

My VBA-foo is too weak for that. But I am getting better. For now I will make a few forms, and then as we tweak the information that needs to be collected for each Resource I will look at making one form and using VBA to show/hide some things. Thanks!

Very subtly. These resources are vendors in the same business, and they all need generally the same information. The information is close enough that it is all stored in the same table. Some vendors might need primary and back-up contacts for example, where others only need primary. Rather than...

I have a subform which contains resources for cases. Each case will have many resources and each resource has their own kick-off form. What I want to do is have a button on each record of the subform that opens a different form depending on the value in the resource combobox. (Even as I write...

I just came out of lurking to thank you for this. I have literally been working on this problem for three hours. I ended up using this on my main form's On Current event: Private Sub Form_Current() Forms.[MainForm].[SubForm].Form.RecordSource = Forms.[MainForm].[SubForm].Form.RecordSource...