The record source of the form is tblCurrentPersonnel. All controls are bound controls. Badge, ID, PIN, Name are text boxes. Currently, I enter the same data into each of them, varying only Name to a slight degree.
What I'd like to have the form do is:
1) I enter a value into badge
2) I move to another control on the form and
3) PIN, ID, and Name values are populated from Badge
4) I'd also need to have Name be editable as I still need to add the concatenation.
Thanks
Terryomsn
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Terry-
>
> OK, what's the Record Source of the form, and please explain how you're using
> Badge, ID, Name, and Pin and how you expect some values to autopopulate.
>
> 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/
> (Villefranche-sur-mer, France)
>
> ------------------------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
> Sent: Sunday, April 22, 2012 7:21 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Forms Population Question
>
>
> Thanks, Duane. I am not storing duplicate values in the table.
> Terryomsn
>
> --- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@> wrote:
> >
> > Terryomsn,
> >
> > I think John was asking for more information regarding your tables. Are you
> really storing multiple duplicate values in the same table? Is the form bound to
> some type of a transaction table? Is there a separate employee table?
> >
> > How about provide more context to what you are trying to do so someone can
> give the best help?
> >
> > Duane Hookom
> > MS Access MVP
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Terry Olsen" <terryomsn@>
> wrote:
> > >
> > > Thanks for your response.
> > > I currently have a bound control for each of four employee fields Badge, ID,
> Name, and Pin. While using the form, I've found that Badge needs to entered, and
> 2 of the 3 other values are always the same and the third (Name) varies only by
> the concatenation of a 2 character code. That works fine if I continue to enter
> the same value 3 times.
> > > While trying alternatives, I added 3 text boxes intending to display the
> value entered in Badge in ID, Name, and PIN after the Badge control had been
> populated and the user moved to another control on the form.
> > >
> > > Do I need to have these 3 additional text boxes or is it possible to
> populate the original bound controls in the same manner?
> > >
> > > I've been studying the Access 2010 Inside Out book. While I have found
> information on what the control and form events are, I haven't found a
> discussion yet that pertains to populating forms in this manner. I am also
> looking for how and when, or if I can, reference the values in the control and
> record buffers.
> > > Thanks
> > > Terryomsn
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> > > >
> > > > Terry-
> > > >
> > > > How is the table containing those three fields related to the table you're
> > > > editing? Access might fetch that info for you automatically if you include
> that
> > > > table in your form's Record Source, and it's linked on Badge.
> > > >
> > > > 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/
> > > > (Villefranche-sur-mer, France)
> > > >
> > > > -----------------------------------
> > > >
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
> > > > Sent: Saturday, April 21, 2012 6:45 AM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: [MS_AccessPros] Forms Population Question
> > > >
> > > >
> > > > For a new entry, I have a data entry form that I want to reduce keystrokes
> on.
> > > > In one bound control, badge, after initial data entry, I want to populate
> three
> > > > other text boxes, txtEmployeeId, txtEmployeePin, and txtEmployeeID. After
> all
> > > > entries on the form are complete, I want to populate fields in the DB
> table
> > > > columns for each of them.
> > > > Which event do I use?
> > > > What persists the data to the relevant DB record?
> > > > Thanks
> > > > Terryomsn
> > > >
> > >
> >
>
Tidak ada komentar:
Posting Komentar