Personally I never use combo boxes bound to data tables unless they are in a grid. Why not use a SQL statement to load up the combo box and they you can initiate the requery() on it whenever you need to refresh the contents. Bind it to a form propery and make the bound field the PK of the records you are selecting in the SQL.
That way you can instantly get the PK of the record selected by looking at the Form Property. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of John J. Mihaljevic Sent: 18 December 2013 21:45 To: [email protected] Subject: Combobox strange behavior Hi all, I have a form that gets information from the user before printing a report. I have an option group for All Accounts or Select Account. If the user chooses Select Account, a combobox becomes active that allows the user to choose the account they want to print. The first time through, it works just fine, showing all the accounts from the table ACCOUNT. The second time through, it will sometimes show data from another table that's open in the system. Here are some of the properties for my combobox: RowSource = account.name RowSourceType = 6 - Fields Style = 2 - Dropdown List The ACCOUNT table is the only one in the Data Environment, although other tables are opened through processing. When the report is done, the last thing I do before returning to the form is to select ACCOUNT again, even though this really shouldn't be necessary. Any ideas as to what I can look for to make sure the combobox shows data from ACCOUNT every time? Thanks very much! John --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
