Populate a field

  • Thread starter Thread starter Angela Byars
  • Start date Start date
A

Angela Byars

I imported several .dbf's from another application to use as the basis for
my form. In addition to displaying the records that were created with the
original application my users will be adding new records. I have one
field - "Request_Type" - which determines what appears in field
"Base_Charge". This field is already populated for the existing records.
How can I set this up to automatically populate "Base_Charge" for new
records?
Thanks,
Ange
 
I imagin the there are only certain choices that can be
entered into Request_type in order to change the
base_charge. If I understand you correctly, this is what
I would do. Put this code in the After_udpate section of
Request_type

Select case request_type
Case is = "First Criteria"
base_charge = "whatever1"
Case is = "Second Criteria"
base_charge = "whatever2"
end select

You can keep that up for as many criteria for
Request_type that you have. (This assumes that your field
names are actually named request_type and Base_charge)
 
Back
Top