Autofill a field with a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to autofill in a cost value associated with a field that is a key
in a table that contains cost values. The user has the option of entering a
value for the cost but I would like to have the default be the value
associated with the particular type description entered by the user (ie user
enters a type of 2, which is printer install services which has a cost of
$50). I want the charge field to default to $50 but allow the user to change
it to $75 without changing the lookup value associated with the type in the
lookup table. I've tried using the DLookup command but it didn't work,
included this on the afterupdate event on the field "type" to insert the
default cost value. Any suggestions? Thanks for your help.
 
I'm trying to autofill in a cost value associated with a field that is a key
in a table that contains cost values. The user has the option of entering a
value for the cost but I would like to have the default be the value
associated with the particular type description entered by the user (ie user
enters a type of 2, which is printer install services which has a cost of
$50). I want the charge field to default to $50 but allow the user to change
it to $75 without changing the lookup value associated with the type in the
lookup table. I've tried using the DLookup command but it didn't work,
included this on the afterupdate event on the field "type" to insert the
default cost value. Any suggestions? Thanks for your help.
Click to expand...
 
Karl, Hi. Thanks for the help. How does your solution create an autofill
in of the cost field from another field's value. The two fields are not in
the same table.
 
When you make a selection from the ListBox the data is filled into the field
of the form. That field of the form has a row source of your cost field.
 
Back
Top