Search results

  1. S

    Complex? Update Query

    I have 2 fields in my db that include the same data type. Field "A" includes a shortform code for a value in field "B". I enter the code for field "A" in a form via a combobox valuelist. This valuelist has 2 columns. Column 1 is the code and is bound. Column 2 is the field "B" equivalent. In my...
  2. S

    Sequential numbered fields

    I have a field called "Sample_ID" within a form. For each new record I enter I want to copy the previous "sample_id" value and add 1 automatically. Example: samp_id 565 566 567 568 569 Any suggestions are welcome.
  3. S

    fill field with value from previous record

    I have a form with fields "From" & "To". I would like to be able to have the "To" value automatically become the "From" value for each successive record. ie: FROM To 5.0 6.5 6.5 7.0 7.0 8.1 Any help would be greatly appreciated.
Back
Top Bottom