Elizabeth-
If you can't reproduce the error, then there is none! Did you test using the
MDE you send to the users?
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 9:17 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Combo Box methods- doing this correctly?
No, this is not a search combo box- the other combo box where they pick a
customer is a search. There won't be any new records (customers). They're all
listed in the search combo box.
As far as the bac_id combo box goes, I do want users to be able to pick a new
value for bac_id. (but I'll save your code for future use!)
I am not able to duplicate the error the user is having when she chooses a new
value for bac_id and it is "not staying". If you think my design of the form is
okay, do you think it could be corrupted? Users have .MDEs and it's a split db.
I find data entry forms tricky to build and always worry that I'm not designing
them correctly.
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar