Jim-
OK, and what are the values in the column in the sequence you want them selected?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 14, 2014, at 2:56 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
The combo box is based on a table named tblColorOfRecord. There is only one column in the table so the bound column is 1
Jim Wagner
On Monday, July 14, 2014 11:10 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jim-
What is the bound value of the combo box? If it's a consecutive number, should be easy to set the Default Value of the control to current value + 1. If not, then I would need to know the Row Source and the Bound Column.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jul 14, 2014, at 2:02 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hello,
I have a question that is a little off the beaten path but here it goes.
I have form that as I do the data entry on the form I have a drop down that I would like to use to always use the next value for the each record. There are seven choices in the drop down. So as I enter the values in the form the next value will only be available almost like an autopopulate. Is there a way of filtering out the values in the drop down to only see the next value or to just autopopulate the field?
Jim Wagner
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar