Results 1 to 4 of 4
  1. #1
    Karen H is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    21

    Question Access 2003 Form:Combo Box will not accept any entry

    I have been a self-taught developer for the past 3 jobs and 20 years but I don't know anything about code. I am currently using Access 2003 and I am having trouble with a Combo Box on a form.

    I had a combo box (based on a table), storing the choice in a field in the query and underlying table the form is based on. Everything was working fine, until... I was trying to figure out how to get the combo box to fill in multiple fields based on the choice made in the combo box. I was not able to figure that out and went back to the original combo box but now when you make a choice from the drop down list you get an error bell and nothing happens.

    I create forms in design view, not based on any template.

    I have other forms with combo boxes that work.

    I have deleted the combo bax and recreated it, set the table property for the field to text box, compacted and repaired, created a whole new form and compared the properties of the form that works with the properties of the form that does not work all with the same results every time.

    I have tried to find the answer to this almost all day every day at work for the past 8 days.

    If anyone can help me, I would greatly appreciate it.


    Karen

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Hi Karen,

    What does the error message say?

    What is the data type for the field in the table (connected to the form)?

    What is the data type of the bound column of the combo box? Are there other columns displayed by the combo box?

    Would it be possible for you to post a sample database (remove sensitive info) with the problem?

    Cheers,

  3. #3
    Karen H is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    21

    Question Re; Access 2003 Form:Combo Box will not accept any entry

    no error message, just a bell. When I copied the db to another file and started deleting all the sensitive information, whatever was causing the problem went away.

    Would it help to delete all the relationships and start that part over?

    Now... on the testing db on the employee tracking form when you look at the assignment the client's names are supposed to be in the drop down box but it is blank. Can you help with that issue please?

    I tried to attach a testing file but there was a security error and our system will not allow it.
    Last edited by Karen H; 01-28-2011 at 11:19 AM. Reason: attachment dropped

  4. #4
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,898
    It sounds like the same issue as: https://www.accessforums.net/forms/l...ard-10812.html
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Access 2003 automatic field entry
    By RANCHLAW56 in forum Forms
    Replies: 6
    Last Post: 12-30-2010, 02:57 PM
  2. Query Won't Accept Criteria from Form
    By Xiaoding in forum Queries
    Replies: 3
    Last Post: 11-30-2010, 01:51 PM
  3. Problems with data entry form Access 2010
    By OfficeQuestions in forum Access
    Replies: 4
    Last Post: 09-23-2010, 01:42 PM
  4. Form does not accept data
    By bongo in forum Forms
    Replies: 3
    Last Post: 03-14-2009, 01:52 AM
  5. Replies: 1
    Last Post: 09-06-2006, 11:48 AM

Tags for this Thread

Posting Permissions

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