Results 1 to 1 of 1
  1. #1
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Populate a ComboBox using a popup form

    I have a popup form that opens from another form and when the command button is clicked on the popup form, it then opens another form,and populates a combobox on that form.


    Problem is this, error message: Filed cannot be updated is what I get. Of course all of the fields do get updated and the code works except for the error message. The error is being generated because I use an expression to populate the field ExpCity (on the final destination form) and it looks up the city,address,etc... Under normal conditions (on destination form) you would click on the combobox and choose a customer and it would fill in the required data, such as address,city,state,zip,phone. BUT the form is being opened via the code from the popup form and populated with that code as well. The combobox uses a query with the expression ExpCity in it that populates the city,address,zip on the destination form.

    Any ideas how to get rid of the error message?
    Attached Thumbnails Attached Thumbnails destinationform.jpg   mainformpopupform.jpg  

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

Similar Threads

  1. Replies: 1
    Last Post: 02-04-2013, 09:48 AM
  2. Replies: 2
    Last Post: 09-08-2012, 08:25 PM
  3. How to populate combobox via VBA
    By chuki2 in forum Programming
    Replies: 7
    Last Post: 08-15-2012, 10:42 AM
  4. Combobox Popup
    By babbelut in forum Programming
    Replies: 1
    Last Post: 05-27-2010, 12:02 AM
  5. Replies: 1
    Last Post: 08-14-2009, 08:41 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
  •  
Other Forums: Microsoft Office Forums