Results 1 to 3 of 3
  1. #1
    NISMOJim is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2010
    Posts
    273

    Can't enter in a combo box with a row source property


    I'm working on my first database since upgrading (?) to Office 2013. This database has a table linked to a table in another database that is constantly updated with new employees using the fields LName & FName. I'm using a query with an expression field to merge the names as EmpName:LName & ", " & FName. My form has a record source of tblXact to log transactions, and a combo box using a row source of EmpName to populate the box with valid employee names to choose from. I've done this with a few other databases and it works great. This time, the names appear, but if I try to select one, I get a message that says "Field 'EmpName' is based on an expression and cannot be edited". I've compared everything I can find with the databases where this works, and can't see any differences. Has something else valuable been done away with in this new version, or am I just missing something?

    Thanks for your input.

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Comboboxes used in this manner are supposed to be Unbound, but from the error message it sounds as if it is Bound. Check the Control Source for your Combobox and make sure that it is empty.

    If you need the employee's name to be stored in the underlying Recordset of the Form, use the AfterUpdate event of the cbo to assign it to a Textbox and have that Control be Bound to the underlying Recordset, instead of the Combobox itself.

    Linq ;0)>

  3. #3
    NISMOJim is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2010
    Posts
    273
    This is a bound combo box, but I found the problem. Since trying it your way I got the same error, I looked deeper into the query. The query had the name field linked to the lookup table of employee names rather than the one it will be saving to. Once I changed the table, all is good.

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

Similar Threads

  1. Replies: 8
    Last Post: 01-31-2015, 11:34 AM
  2. Replies: 8
    Last Post: 09-19-2013, 03:07 PM
  3. Column Control Source Property
    By rts in forum Reports
    Replies: 6
    Last Post: 05-17-2012, 06:42 PM
  4. Can I Enter Sub Name In On Click Property?
    By Soule in forum Programming
    Replies: 2
    Last Post: 03-05-2012, 11:01 PM
  5. SQL vs. vba Row Source property
    By eww in forum Programming
    Replies: 7
    Last Post: 10-15-2010, 11:02 AM

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