RE: Replicating fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello Klatuu,

Another question i am afraid:

If I had a text box called txtThirdBox, could that lookup the text that was
created in txtSecondBox that was brought in from txtFirstBox?

I ask this because I have 8 text boxes that I would like to update, each one
copying from the previous one.

Good question, yes?

Regards,

Paul


"Klatuu" wrote:

> Paul,
>
> The answer depends on several variables, but let's see if we can work this
> out. A form is what you put text boxes, command buttons, combo boxes(drop
> downs) and other controls so you can view and manipulate your data. Usually,
> a form is bound to a table or query. Tables are where the data are stored
> and queries are a way of creating logical tables - not really tables, but
> conceptually you can think of them as working like a table, but are really a
> way of organizing and viewing your data.
>
> Based on your post, I am assuming you are working with a form and you want
> to put a value in a text box and have that value appear in another text box
> on the same form.
>
> lets say you have two text boxes txtFirstBox and txtSecondBox. In the After
> Update event of txtFirstBox, select code builder and put this code:
>
> Me.txtSecondBox = Me.txtFirstBox
>
> If this is not what you are trying to do, let me know.
>
> "Paul" wrote:
>
> > Hello Klatuu,
> >
> > Thank you very much for replying to my query.
> >
> > Yes, I think I have the terms wrong.
> >
> > What I trying to do is have a form, or do I mean table? where if I put a
> > name (text) in one field it would also appear in another designated field.
> >
> > I am sure this is simple but I cannot find out how in my books or in the
> > "help" section.
> >
> > Thank you very much for trying to help me.
> >
> >
> > "Klatuu" wrote:
> >
> > > Paul,
> > >
> > > Do you mean text boxes on a form? Forms don't have fields, they have
> > > controls. It may depend on when you want it to happen. When you move to a
> > > new record? When you enter a value in the first control? Are both fields on
> > > the same form? If not, is one a sub form? If you could please provide a
> > > little more detail, I would be happy to help.
> > >
> > > "Paul" wrote:
> > >
> > > > Hello, could somebody please help with my problem?
> > > >
> > > > I want one field in a form to look up the text in another field and place it
> > > > in that field.
> > > >
> > > > Iy you could help I would most oblidged
.

Relevant Pages

  • RE: Replicating fields
    ... Paul ... A form is what you put text boxes, command buttons, combo boxes(drop ... > downs) and other controls so you can view and manipulate your data. ... select code builder and put this code: ...
    (microsoft.public.access.forms)
  • RE: Replicating fields
    ... A form is what you put text boxes, command buttons, combo boxes(drop ... downs) and other controls so you can view and manipulate your data. ... select code builder and put this code: ... "Paul" wrote: ...
    (microsoft.public.access.forms)
  • RE: Replicating fields
    ... Do you mean text boxes on a form? ... controls. ... "Paul" wrote: ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: splash screen macro problem
    ... Use the backcolor property for the Userform and the controls. ... > "Tom Ogilvy" wrote in message ... >>> object and text boxes within have background colors, ... >>> Paul ...
    (microsoft.public.excel.programming)
  • RE: Checking for null fields before running query
    ... I could use that sub and modify it so that it checks for Null in the ... return at least one record when all 3 controls have values. ... 3 cbo boxes, 2 buttons, 12 txt fields. ... the cboboxes provide parameters for a query, and also criteria for 12 DSum ...
    (microsoft.public.access.modulesdaovba)