Populate a field based on other fields

[Rickinnocal]

On my form I have a text field, txtCharge, which will contain the base price for a job. There is also a combo box where I select the client, and one where I select the port.

I have a table called tblPricing which has a row for each client and a column for each port. The base price for each client at each port is entered.

If I select "ABC Shipping" for client and "Los Angeles" for port, I'd like the base price to populate the Charge field.

How do I go about this, please?

Thanks,
Richard

[June7]

When you say field, txtCharge, this is actually textbox name? The field in table is Charge? txtCharge is bound to Charge?

You can have code do a DLookup() to retrieve price or ID.
Me!Charge = DLookup("Price", "tblPricing", "ClientID=" & Me.Client & " AND PortID=" & Me.Port)

The real trick is figuring out what event to put code into. Possibly need to use AfterUpdate event of both comboboxes.

[Rickinnocal]

Thanks, I'll give it a shot. Probably run it on the GotFocus event of the field itself so that the cursor is there ready to type if I want a different price for some reason.

[Bob Fitz]

I have a table called tblPricing which has a row for each client and a column for each port. The base price for each client at each port is entered.

Not sure that June's suggestion will work if you do actually have a column in the table for each port and only one row for each customer.

[June7]

Ooops, I missed "column for each port". tblPricing is not normalized. Consider this instead:

Me!Charge = DLookup("[" & Me.Port & "]", "tblPricing", "ClientID=" & Me.Client)