Lookup Problem!

[Dave Elliott]

I need to lookup a value from one table and put in another table as the
default value.
Customers table has a field called Customer Rate
Time table has a field called Rate
I am trying to make my form TimeCards which has it's record source based on
the table Time use the value of
the Customers table field Customer Rate as it's default value.
Adding the table Customers to the query grid with the field Customer Rate
does not seem to make.
I have a field on the form TimeCards which looks up the Customer Rate and
tried to set the default of the value to
the desired field on the TimeCards form which is named Text500, but this did
not work.

What can I Do ?

 

[Guest]

Hi, Dave.

Maybe the easiest way to implement this is to include the Customer Rate as a
column in a combo box for the Customer Number and use the Column property of
the combo box. Something like the following for the combo box' RowSource
property:

SELECT Customers.CustomerID, Customers.Name, Customers.CustomerRate FROM
Customers ORDER BY Customers.Name;

Then set the DefaultValue property of the form field that stores the Rate to:

=Me!MyComboBox.Column(2)

Hope that helps.
Sprinks