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
>
Tidak ada komentar:
Posting Komentar