My First Module...questions

R

Rob S.

I need to write an update query that calls a module, and I can't figure out how to set up a module. I've successfully coded a ton of forms, though this is proving very difficult for me

The table (tblDataBT) contains fields such as: Cost, Unit1, Description, Date which are to be updated with segments of data from field "Source" which is located within the same table, depending upon the value of the first 6 characters of "Source

I was hoping to use select case, because it's the most straightforward for me

Select Case left([Source],6
Case 10279
Cost=mid([Source],20,10
Case 10051
OCC_Q=rtrim(mid([Source],27,15
UNIT1=mid([Source],19,11
UNIT2=mid([Source],63,11
UNIT3=mid([Source],96,11
UNIT4=mid([Source],107,11
UNIT5=mid([Source],118,11
UNIT6=mid([Source],129,11
'many more cases will be include
End Selec

Can anyone show me how to start the module? Basically, I need to know how to get the module to understand the fields within the table

Thanks!
 
Top