Selecting Multiple "Values" without lookup tables & Other question

[Rob]

QUESTION #1
I've built many-to-many relationships that should allow me to apply several
different categories for a given company record (i.e. the companies being
tracked are involved in several different businesses). Now the question is,
how do I set the form up to allow me to select the applicable categories?

I'd rather not use lookup columns as I want to be free to port the DB over
to SQL at some future time.

QUESTION #2
Why does a tabular form show up in form view when I enter design view? Much
more difficult to get things looking the way that I want them this way. The
size of the tabular subform appears to change drastically when switching
between layout view and form view such that I can't setup the columns etc.
with any predictability whatsoever.

QUESTION #3
Is there a way to build 2 subforms that are more or less identical to the
user, but which automatically make a particular entry to a given field based
on which subform I entered the data into?

QUESTION #4
By now, I'm sure you have determined that I'm new to the world of Access.
Any recommendations on good books for Access 2007?

Thanks in advance,
Rob

 

[DStegon via AccessMonster.com]

#1 Put a combo box on the form that shows the categories. When you choose
the category have the control filter the data on the form. I am assuming you
have a form that has a table as the record source and have it in some view to
show all the records. The combo box can go in the form header of the form.

put code like this in the afterupdate event of the combo box
Private Sub Combo0_AfterUpdate()

If Len(Me.Combo0 & "") > 0 Then

Me.Form.FilterOn = True
Me.Form.Filter = "categories = '" & Me.Combo0.Value & "'"

End If

End Sub

categories is assumed to be the name of the field. If you have table that
has the categories in them and they have an ID for each then use the ID and
have the combo box have both values, ID and categories description, hiding
the ID (setting it to 0" in the column width) and setting the bound column to
1 (assuming you have two columns).

#2... I hate bound forms that are designed by the wizards. I design all my
own forms and place my controls where I want them to be. So I am not really
the guy to ask about this one.

#3 .... Huh???