How Do I “Push Data” From 1 Control To Another?

[BobL via AccessMonster.com]

The requirement is to create a browse screen within a form. There is to be no
manipulation of the data in the referenced table. There is only 1 table. To
do this, I have created 4 ComboBoxes to enable searches on 4 different fields
in the table. My objective is to pass the record pointer from any 1 ComboBox
to the other 3 ComboBoxes and to all the TextBoxes on this same form. I have
seen it work in real applications, sample applications, and books by “pulling
the data”. By “pulling the data”, I mean the focus is on the receiving object.
I require “pushing the data”. I have seen 1 example of this in the Northwind
Order Form. The way the data seems to be pushed from the “Bill To Customer ID
ComboBox” to the “Bill To Address TextBox” below it and to the “Ship To
ShipName TextBox” to the right of it looks like an ideal way to populate all
of the controls on my form. However, I have not been able to follow how it
works. Can anyone help?

 

[Guest]

It would be easier to suggest a solution if you expressed what you wanted to
do rather than how you wanted to do it. On first impression you seem to have
come up with a very convoluted way to achieve something fairly simple.

Dorian

 

[BobL via AccessMonster.com]

The requirement, as you summarized below, is to create a browse screen within
a form. This browse screen needs to allow users to 1)pick a value from a drop
down list or 2)enter a value. The rest of the fields should then be populated
from that same record.

This is to be a read-only application. No manipulation of the data in the
referenced table.

Can you help me?

It would be easier to suggest a solution if you expressed what you wanted to
do rather than how you wanted to do it. On first impression you seem to have
come up with a very convoluted way to achieve something fairly simple.

Dorian

The requirement is to create a browse screen within a form. There is to be no
manipulation of the data in the referenced table. There is only 1 table. To

[quoted text clipped - 9 lines]

of the controls on my form. However, I have not been able to follow how it
works. Can anyone help?