Linking records in forms

L

langirl77

Hi,

I have a database for our asset tracking, it's got hardware and software
info. I have created a problem history button that pulls up another for so
you can view or edit past problems with the hardware. How do I link the 2 so
that when I am viewing a record and click problem history, only the problem
history for that serial number comes up?

THanks.
 
J

Jackie L

You can use the button wizard to create the button to open the history form,
choose select specific records, and choose the common field. Otherwise, you
can base your history form off a query and in the criteria field, use the
expression builder to point to the common field on the main form like
Forms![frmMainForm]![CommonField]

Hope this helps. Jackie.
 
L

langirl77

What do you mean common field? I did create a button and it opens the
problem history. But for any record I pull up and select the button it pulls
up all of the problem history, not just for that record.

Thanks.

Jackie L said:
You can use the button wizard to create the button to open the history form,
choose select specific records, and choose the common field. Otherwise, you
can base your history form off a query and in the criteria field, use the
expression builder to point to the common field on the main form like
Forms![frmMainForm]![CommonField]

Hope this helps. Jackie.

langirl77 said:
Hi,

I have a database for our asset tracking, it's got hardware and software
info. I have created a problem history button that pulls up another for so
you can view or edit past problems with the hardware. How do I link the 2 so
that when I am viewing a record and click problem history, only the problem
history for that serial number comes up?

THanks.
Click to expand...
Click to expand...
 
Top