Excluding Clients from specific Forms

[robertmeyer1]

I have 2 types of forms, sbf’s and mainforms and they are all based off of 2 tables. The sbf’s are based off of tblAnswers which is appended through a query and is used to prepopulate a list of questions for clients. The other forms are based off of tblClient. This allows for all clients to be shown on each form, and the sbf’s with matching ClientID’s to be displayed and thus allowing answers (numeric) to be filled in to a corresponding question while linked to a specific client.

On one of the mainforms (frm1) I have a drop down list which has 5 choices (A-E). When people choose this selection and click “continue” it takes you to 1 of 5 forms (frmA-E). So 1 client should only have information on 1 of the 5 forms.

However, these forms (A-E) are also mainforms, so all clients are contained in each form. That is client 101 has information displayed in frmA, frmB, frmC, frmD, & frmE even though on (frm1) he may have selected A from the drop down box.

While frm1’s continue button allows for client 101 to continue to the correct form (frmA); the potential exists for someone to get to frmB-E and enter information for client 101 here (which would screw up the DB).

So I am wondering if anyone has any suggestions on how to remove client 101 (or any other) from a form different than selected. Or if not removing; to at least hide a clients information if it is not matching the corresponding form.

I know in queries you can do that in a criteria; can this be applied to a form based of a table as well? Any other ideas? Thanks.

[NeoPa]

Add a field to the tblClient table to store the selection.
When not set the ComboBox can be used to update the record.
When previously set, the value displays as is.
All forms have a filter which selects only those records with their own form code in them.

[robertmeyer1]

Add a field to the tblClient table to store the selection.
When not set the ComboBox can be used to update the record.
When previously set, the value displays as is.
All forms have a filter which selects only those records with their own form code in them.

Very Cool. I altered the record source to a query based off the tblClients which included the ComboBox and not it excludes all others from this form. Thanks for the help.

[robertmeyer1]

This thread is now closed