Lookup/Combo box calulation

[kmims44]

I have a lookup field on a table that is a combo that displays one field which is Currency called "Field1"


I have another field in the table that is a number called "BudgetedHours"
I want to have a field on a form that when a user selects from (Field1) the field automaticly multiplies it buy the hours but for some reason I cannot get this to work. I'm assuming because its a combo lookup field but not sure how to get around that.

[Missinglinq]

First off, are you speaking Lookup fields as defined in a Table? Or is your lookup field done through a Combobox on a Form?

Lookup fields defined in Tables are frowned upon by experienced developers, for a number of reasons, explained here:

The Evils of Lookup Fields in Tables

Comboboxes in Forms, which are sometimes called "lookup fields" are both safe and handy. If this is what you're attempting, let us see the code you're currently attempting to use.

Linq ;0)>

[kmims44]

the lookup field is in the table the form has the combo box that links to the lookup field
i don't have code for it for you to look at because nothing I have tried hsa worked a blank slate right now