ACCESS FEED: Re: [MS_AccessPros] Combo Box methods- doing this correctly?

Kamis, 19 Mei 2011

Re: [MS_AccessPros] Combo Box methods- doing this correctly?

1.SELECT BusAffContacts.ID, BusAffContacts.BAffCLName, BusAffContacts.BAffCFName FROM BusAffContacts WHERE (((BusAffContacts.ID) Not In (433,434,435,436,437,438,439,440,441))) ORDER BY BusAffContacts.BAffCLName, BusAffContacts.BAffCFName;

2.BAC_ID

3. 1

4. nothing

5. 2003

thanks again for your help.

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Elizabeth-
>
> Please answer these questions:
>
> 1) What is the Row Source of the combo box? Please post the text from SQL view.
>
> 2) Is there anything in the Control Source property of the combo box?
>
> 3) What is the value in the Bound Column property?
>
> 4) What is the code in the AfterUpdate event of the combo box?
>
> 5) What version of Access are you using?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of glcass58
> Sent: Thursday, May 19, 2011 6:54 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Combo Box methods- doing this correctly?
>
> Hi everyone,
> I have a pretty straight forward data entry form based on a query where the user
> uses a combo box to pick a customer (created with the wizard) and then enters
> data about that customer.
> On it there is a combo box that looks up values in another table and stores the
> chosen value in a field. I used the Wizard to create it.
> The data entry person is having problems with this field. She says that the
> value she chooses "isn't staying" and then when she goes to another control on
> the form (a text box)the form switches customers on her.
> Any ideas why? The query the form is based on is two tables, a one-to-one
> relationship.
> Your help is greatly appreciated.
> Elizabeth
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>