Results 1 to 5 of 5
  1. #1
    MTSPEER is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    283

    New Records

    I have to create a form with entries like member name, ID number, Contact Phone, fax. And I want to add a combo box. But I have no data. I want to create the form. and each individual record i make in the form I want it to save the data in a table. Is that possible? Do I make fields first in a table then create a form? I tried that, and whenever I create the first record then go to the next one the same infomration is kept for the next form which I dont want. The combobox information stays the same for every record



    And I Want to keep the Phone Number and Fax the same for every record

  2. #2
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    First make the table with the desired fields.

    Second, make the form, using a wizard, and using that table as the source. This will give you a form that will automatically save any data you input, to the table, as you have requested.

    After that is done, on the form, set the default values of the phone and fax text fields to the values that you want. (design view, right-click the text box, open the properties window, data tab, default value) That way, any new records you add will automatically get the right value.

    (You can also do an update query to add this to existing records, but I wouldn't suggest that for a beginner. Please back up your database OFTEN while you are trying things.)

    I'm not sure what information you want to have in your combo box, so I can't tell you where to get it from. If you are thinking of using a combo box in the form header, for example, to select which member appears in the form detail screen, that's a little more advanced than I'd suggest for you at this point.

  3. #3
    MTSPEER is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    283
    The field I want to use the combo box for is called Referral Source. And the items I want to put into the combo box are: Physician, Home Care, Concurrent, Marketing, Med Director, CSO, Precert, and Other. Then I want a text box or something so they can write what "other" is. But whatever I pick for the combo box I want it to enter the data back to my field in my table. And when I choose an option for that combobox it will save it for that record, so when I make a new record it wont have the same information I input.

    Also, when I try setting that to the default value it's not giving me the right number. it's putting some negative number

    -And it won't let me create a new record after the second record. I think it's because I didn't enter the primary key for the second record?

  4. #4
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    In general, I would make a small ReferralCode table that had just an autokey and the item description (1 Physician, 2 Home Care, 3 Concurrent, 4 Marketing, 5 Med Director, 6 CSO, 7 Precert, and 8 Other), then bind your combo box to that table. Remember that the KEY (1 for Physician, etc) is what will be stored in the referral field on the main table.

    For now, you can include the text Note field where "OTHER" will be filled in on the same table. If you chose, you could fill in more information about the referring doctor/marketing/Precert there as well.

    By the way, you can save yourself some trouble by not using spaces in the middle of your table and field names. Otherwise, you end up having to put braces [] around everything.

  5. #5
    MTSPEER is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    283
    Okay, thanks. I got the the combo box to save in every record. But for some reason It wont save to the table. it worked for record 2-it saved the data to the table. But then after that it just stopped. It wasn't recording any information to the table.

    -Thanks for the tip the the field names

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-28-2013, 04:00 PM
  2. Replies: 1
    Last Post: 02-16-2013, 11:36 AM
  3. Replies: 1
    Last Post: 01-24-2013, 05:50 PM
  4. Access 2007 - Creating New Records Based on Existing Records
    By GeorgeAugustinePhillips in forum Forms
    Replies: 9
    Last Post: 10-05-2011, 05:58 PM
  5. Replies: 12
    Last Post: 08-30-2011, 03:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums