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

Kamis, 19 Mei 2011

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

Elizabeth-

So, this isn't a "search" combo box. Selecting a value in the combo should set
the BAC_ID of the current record. Tabbing into another control should *not*
change the value. Is there any other code in this form?

Note that if the user is on an existing record, selecting a new value in the
combo box WILL change the value of BAC_ID in the current record. You probably
intend for the combo to be used only on a new record. You could assure that
this happens by putting the following in the form Current event:

Private Sub Form_Current()

' If not on a new record
If Not Me.NewRecord Then
' Lock the BAC_ID combo so it can't be changed
Me.BAC_ID.Locked = True
Else
' Unlock for a new record
Me.BAC_ID.Locked = False
End If

End Sub

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 8:40 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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
>

------------------------------------

Yahoo! Groups Links