Filtering Forms

[Lupson2011]

Hi



I am developing a database where there are two strands of funding, with people being able to apply to one or both. I have created two sides to the database (SChange & SImpact) to cater for this.

Each side of the database has several tabs formatted for Project Details, Budget, Help.

Now, what I wanted to do was to show all records on the SChange side as everyone would be applying to that strand. But, depending in they checked a certain box on the SChange side indicating whether they were applying to both strands or just the one, if I went in the SImpact side, it will only show the records that have indicated they are applying to both. Essentially adopting a filter for which I did the code below

Private Sub Command117_Click()
On Error GoTo Err_Command117_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "SImpactContactDetails"

stLinkCriteria = "[ChangeAndImpact]= true"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command117_Click:
Exit Sub

Err_Command117_Click:
MsgBox Err.Description
Resume Exit_Command117_Click

End Sub

This successfully only shows those records that are applying to both in the SImpact side and also automatically puts the contact details in (saving time inputting them again).

Now, the problem comes with the other tabs, as the Project Details tab is the only one where the information between SChange and SImpact will be the same. The budget/help etc.. will be differernt information. But at the moment it automatically populates all fields withe same info

Bascially, I am after a form filter with automatically data entry, but only on the first tab (project details). After that I want to put in different information.

Is there a way I can do this, or do I have to approach the whole filtering thing differently?

Any advice greatly received

Bagpuss

[June7]

Should not put contact details into both tables. Have a table for People and then foreign key fields in the other tables for the PeopleID. Sounds like also need a Projects table and again foreign keys in the other tables for ProjectID.

Do you want to provide project for analysis?