How do I cause a "record find" to open before a form?

[Just Me]

Table A contains a list of colors (example red, blue, green)

Table B contains a variation of the colors in Table A (example
light-red, medium-red, dark-red)

To add a color variation to Table B, I want it to open a find record
dialog box before it opens the form so that you can locate the main
color you are going to enter the variations for. The form should then
open with the information from Table A already preloaded (or a dialog
box should ask you to confirm if you were entering a color variation
for, say, Red (or any other color in Table A)).

Does this make sense? How can I do this?

TIA

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Why not just use a datasheet subform? You could put the data from Table
A in the main form & the data from Table B in the subform. The
subform's Child/Master link fields would be the color id from table A.
This means you'd have to have Table A's color ID as a column in Table B.
E.g.:

Table A:
ColorID
ColorName

Table B:
ColorID - links to Table A
ColorName - the "shade" of color in table A.

When the color "Red" is in the main form the subform would show:

Light Red
Medium Red
Dark Red

When the main form color changes the subform colors would change to
match the ColorID in the Child/Master link fields.

Then you could use the Find function (Ctrl-F) on the main form's color
name field to find the main color.

This is a much easier procedure than opening multiple forms.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQMYL+oechKqOuFEgEQLYhwCfR6z0bWyLhgAEyb7kMUYbJr cSjocAoP8J
djNl5Ab6/DqxPWg5IF/5QdsN
=qrAr
-----END PGP SIGNATURE-----
Just Me wrote:

Table A contains a list of colors (example red, blue, green)

Table B contains a variation of the colors in Table A (example
light-red, medium-red, dark-red)

To add a color variation to Table B, I want it to open a find record
dialog box before it opens the form so that you can locate the main
color you are going to enter the variations for. The form should then
open with the information from Table A already preloaded (or a dialog
box should ask you to confirm if you were entering a color variation
for, say, Red (or any other color in Table A)).

Does this make sense? How can I do this?