Open forms displaying specificic information

[Johnjmn]

I am creating a database to track support calls. I have 3 forms all related
through a customer number. I have main customer information a form with 2
command buttons that open forms in order to display product info and support
info. The only info required on these forms opened by these command button
is info related to that customer number. ie I'm on customer information, I
hit support info button, form comes up with only support info (could be
multiple job #) for that customer number.
TIA

 

[Brian]

Use Customers form to select a customer. Make sure CustomerID is on the form,
either displayed or hidden in a text or combo box, then open Support form by
button click on Customers form. RecordSource of the Support form should be
something like this:

SELECT Support.* FROM Support WHERE Support.CustomerID =
[Forms]![Customers]![CustomerID]

You could go multiple levels deep with this: Customers -> Jobs ->
SupportDetail, etc.

This will show just the support info for that single customer. Make sure to
make both forms modal to prevent the user from closing the Customers form
while the Support form is open and thus losing the record source reference to
that form.