By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,133 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
-----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.