ACCESS FEED: RE: [MS_AccessPros] Auto Populate from a drop down box

Senin, 14 Juli 2014

RE: [MS_AccessPros] Auto Populate from a drop down box

What happens if there are 8 records when there are only 7 options? Are these populated over a group of records based on another field in the table? Can you share some table and field names?

Duane Hookom MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com; MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 14 Jul 2014 12:45:28 -0700
Subject: Re: [MS_AccessPros] Auto Populate from a drop down box

vbBlack
vbBlue
vbCyan
vbGreen
vbMagenta
vbRed
vbYellow

Sent from Yahoo! Mail for Windows 8

From: John Viescas JohnV@msn.com [MS_Access_Professionals]<MS_Access_Professionals@yahoogroups.com>
Sent: ‎Mon, ‎Jul‎ ‎14‎, ‎2014 at ‎12‎:‎11‎ ‎PM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Auto Populate from a drop down box

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

http://www.viescas.com/

(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

http://www.viescas.com/

(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