2 prblemsm, should be simple to solve both regarding record source

[OC2]

Hi,

First problem,

Im doing a contact database which uses two tables,
First table is clientA and the second table clientB.
Each client needs it own table as the data required is different for each of them.

When I add a new contact, I want to use only one contact update form which can add the contact to the relevent table.

Heres how I want to do it. I want to use a combo box. The values ClientA and ClientB will be the options to choose from. If I click on ClientA it will change the record source to ClientA, if I click Client B it will change the record source to Client B.

Any idea on how to do that?

Second Problem.

How do I view a report based on a forms filtered record source? i.e. I have a search feature on my form, after I have done the search I want the info illustrated on a Report.

Any ideas how I do that?
When I tried it says the report needs to be open to update its record soure, and when the report is open it says already printing report (its not though)

Any help will be greatly appreiciated.

Thx Regards


Tom

 

[OC2]

sorry for the unacceptble spelling on the title

 

[Aivars]

Hi!

First problem:
Private Sub cboRecordSourceChange_AfterUpdate()
Me.RecordSource = IIf(IsNull(Me.cboRecordSourceChange), "", Me.cboRecordSourceChange)
End Sub

Second Problem.
Yes, you can use the search results on a Report.
Example:
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Forms("MySearchForm&quot.RecordSource
'Also you can set many others form's and object properties on your Report
End Sub

Regards!
Aivars