Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Darkest Kent, UK., Kent, England
    Thanked 0 Times in 0 Posts

    How to save field data to table? (A2KSR1)

    I know this is Day 1 stuff, but here goes:

    How do I save the data in a calculated field to the underlying table?

    I have a simple form called "F:Enter New Record" based on a table called "T:Tracking Data". On that form is a field called 'Unique_ID' whose source is =[ComboBox1] & "_" & [ComboBox2]. What I'm looking to do is select a value in each of the two combo boxes, but only store the value of the Unique_ID field in 'T:Tracking Data'.

    I REALLY need a refresher course. My version 2.0 days seem so far away now.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: How to save field data to table? (A2KSR1)

    Why don't you bind ComboBox1 and ComboBox2 to two separate fields? Access will store the values in the table automatically. You can reconstruct Unique_ID in a query.

    Storing the concatenated value would require the use of VBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts