Recent content by fearless

All I have a form where the user can select which report to run. When the user clicks a command button the selected report is exported in RTF format. Other buttons allow preview or printing Code for the export to Word (RTF) follows. Private Sub cmbTo_Word_Click() Dim stDocName As String...

Thanks for your reply. It prompted me to review my design and simplify what I am trying to do. Fearless

I have a mainform with a search function so the user can select a record to view and update. The selected record is displayed in Subform1 on Page1 of a tab control. The record source of this form is Query1. Page2 of the tab control contains Subform2; record source is the result of Query1...

Peter Thanks very much. Works like a charm. Fearless

I have a report with the following unbound text boxes in the detail section. TextNm and Text0-Text5. I am trying to assign values to each using the following code. However each assignment statements (Me!TextNm = rst.Fields(i).Value) produces the following error "You can't assign a value to...

Thanks for your responses, I am studying your suggestions now.

I have the following tables, tblAudit and tblCriteria. The first records companies and period of audit, the second contains the criteria against which they will be audited. The audit period determines which criteria apply. Results are recorded in a third table, tblAuditResults. Relationships...

I have a main form with a control that can take one of three values. And I would like to add a subform that work as follows. Selecting each value should change what the subform displays like this. Control Subform A Select * from TableA where Key = "A" B...