Hi Reed,
I've never heard it referred to as pushing data, but there is an example in
the sample Northwind database. Search your hard drive for Northwind.mdb. If
you cannot find it, then you should be able to add it using your Office
installation media.
On the Orders form, when you select a customer in the "Bill To:" combo box,
the address information is pushed to the appropriate textboxes, using the
CustomerID_AfterUpdate() event procedure. The columns are zero based, when
referring to them in VBA code:
Private Sub CustomerID_AfterUpdate()
' Update ShipTo controls based on value selected in CustomerID combo box.
Me!ShipName = Me![CustomerID].Column(1)
Me!ShipAddress = Me!Address
Me!ShipCity = Me!City
Me!ShipRegion = Me!Region
Me!ShipPostalCode = Me!PostalCode
Me!ShipCountry = Me!Country
End Sub
If you look at the Row Source for this combo box, you will see that
column(0) corresponds to the first field selected (CustomerID), column(1)
corresponds to the second field selected (CompanyName), etc. Here is the Row
Source:
SELECT DISTINCT Customers.CustomerID, Customers.CompanyName FROM Customers
ORDER BY Customers.CompanyName;
In this example, they are bringing in most of the fields via the Record
Source (Orders Qry). You can include the fields you wish to push in the Row
Source for the combo box, but just set the width for these columns to zero,
effectively hiding them.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
I have a table named Recruitment.
I have a form with a lookup designed in it to fill in 2 fields in the table
Recruitment. One field is RecruitmentNumber ie 2005-001. The second is
ClassificationTitle ie Chemistry Instructor.
Once selected in Lookup, I would like both fields in Recruitment to be
filled.
I have heard that the process is called pushing. But I have not found any
good examples or heard any good explanations.
Please help.
Thank you in advance!
