469,920 Members | 2,187 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,920 developers. It's quick & easy.

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

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
Nov 13 '05 #1
1 1654
-----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?


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by EricRobineau | last post: by
reply views Thread by William Wisnieski | last post: by
25 posts views Thread by tekctrl | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.