using groups for data entry

[Yeam69]

I have a database for contact management, but I want to filter/group for the
data entry, which I will try my best to explain here what I need to do.

When entering a company, we always report on our data by members or
non-members (we are a trade assocaition), and the members are then split down
into the membership category (relates to the company activity) i.e. property
developer, lawyer etc. The issue I have is that when creating my forms
(using tabs/subforms) there are some tables which I do not need for thye data
on the non-members, and indeed some which I do not need for layers, wheres
for the property develoers I need to gather much more information and thus
they have more tables. I was therefore wondering if I could create the data
entry forms based on groups i.e. one form with relevant subforms/tabs for non
members, and for members, and again the members group further split by
membership category. Therefore the tabs/subforms would differ depending upon
which group (master form) selected.

 

[Arvin Meyer [MVP]]

A subform is not a form, until it gets focus, it is a control, the same as a
text box. You can, therefore, change the SourceObject property of that
subform control. A form (or form used in a subform control) also has a
recordsource property that can be changed before opening it, or, after
opening can be changed and requeried. So:

The most efficient method would be to open a form based on a query that
shows your most common group. Use a command button to make changes to
subforms that are on other tabs, something like (aircode):

Sub cmdChangeSource_Click()
If Me.subformControlName.Form.SourceObject = "qryNonMemberDetails" Then
Me.subformControlName.Form.SourceObject = "qryMemberDetails"
Else
Me.subformControlName.Form.SourceObject = "qryNonMemberDetails"
End If
End Sub

That should get you started. Post back if you need any more specific
information.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Larry Daugherty]

Without understanding much about your application, the answer is still
"Yes".

HTH