Form with Subform

  • Thread starter Thread starter Lucas
  • Start date Start date
L

Lucas

I'd like some advice on the best way to do the following:

I'd like to make a form, called Contacts, where our
employees type notes about the people they call. Now
there are a lot of things I'd like to do, but I don't
know if I'm competent enough to do them.

I'd like to design a form where the user selects a client
from a combo box and can then scroll through records of
conversations for just that client (and of course add new
ones). When they select that client, the clients
address, phone number, etc appear in the appropriate
fields.

I'm fairly new to form design and would appreciate any
advice on how to set up the tables/forms (and subform?).

Thank you,

Lucas
 
Lucas said:
I'd like some advice on the best way to do the following:

I'd like to make a form, called Contacts, where our
employees type notes about the people they call. Now
there are a lot of things I'd like to do, but I don't
know if I'm competent enough to do them.

I'd like to design a form where the user selects a client
from a combo box and can then scroll through records of
conversations for just that client (and of course add new
ones). When they select that client, the clients
address, phone number, etc appear in the appropriate
fields.

I'm fairly new to form design and would appreciate any
advice on how to set up the tables/forms (and subform?).
Click to expand...

Main form based on the clients table showing the address, phone number etc..

Subform within the main form showing the details of the conversations.

Unbound ComboBox labeled "Go to..." or similar on the main form that lists all of the
clients for selection. Make the Combo include the Primary Key field for clients and
make that the bound column. You can hide that column and only display the client
name for selection. In the AfterUpdate of this ComboBox run code to filter the main
form to the selection made.

Me.Filter = "ClientID = " & Me![GoToComboName]
Me.FilterOn = True
 
Back
Top