Results 1 to 3 of 3
  1. #1
    Peter_ is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    2

    Question Combobox with linked Oracle table

    I have my form connected to a linked table (ODBC Oracle). One field has a 1-n relation to another table.
    I want to display the value of the other table in a combobox (and selecting another item should update the main table).
    Neither the usual way for Access tables (Lookup) nor setting a query as recordsource of the combobox does work. Doing the latter, the combobox is filled when popping up, but the correct entry is not shown in default state.


    Any ideas?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,863
    So, the problem is not connecting to Oracle, the problem is the order the query sorts the records? What do you mean by 'default state'?

  3. #3
    Peter_ is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    2
    Default means no popup. I have solved the Problem, seems to be a mistyping.
    Thanks.

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

Similar Threads

  1. Replies: 6
    Last Post: 04-05-2015, 07:33 AM
  2. Replies: 3
    Last Post: 08-09-2013, 05:12 AM
  3. oracle Link table query
    By mapache in forum Queries
    Replies: 1
    Last Post: 11-19-2012, 07:38 AM
  4. Replies: 1
    Last Post: 10-15-2012, 02:41 PM
  5. Oracle table name exceeds 30 char?
    By workindan in forum Access
    Replies: 0
    Last Post: 12-08-2010, 02:59 PM

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 - Senior Forums