Re: Update text box based on data in combo box

Tech-Archive recommends: Fix windows errors by optimizing your registry

Me and Value are to be used as is.

Me is a "built-in" object in VBA that means the object to which the module
belongs.

Value is a property of a control.

--

Ken Snell
<MS ACCESS MVP>

"Ember" <Ember@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8409229D-81C5-46DC-8DE8-6224EEDC1696@xxxxxxxxxxxxxxxx
Thank you Ken...I had done it backwards where I used the unbound solution
as
VBA code and the VBA code in the control source.

One more thing...could you please tell me (in the bound solution) if I
still
use "Me." and ".Value" or do I need to use my own wording.

Thanks!

"Ken Snell (MVP)" wrote:

See this article at The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm
--

Ken Snell
<MS ACCESS MVP>


"Ember" <Ember@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B38E3C27-748C-4428-A498-76AE2D17ABBC@xxxxxxxxxxxxxxxx
I have searched for my specific issue but did not find any responses. I
found several "close" ones and tried to manipulate the responses to fit
my
issue, no luck!

I have tblFiles on which frmProjectFiles is based. I have a make table
query qryProjects which groups "Project Name", "Project Number", and
"Project
Manager" from entries in tblFiles and then creates tblProject.

I would like to on frmProjectFiles to be able to select a "Project
Name"
and
the "Project Number" and "Project Manager" would be auto entered. I
also
need users to be able to enter new information for each field as new
projects
are created.

I have tried to manipulate the AfterUpdate property of "Project Name"
to
fill in the text boxes, but could not get any configuration I could
think
of
to work.

I have tried Dlookup in the control source of "Project Number" and
"Project
Manager" but get a "circular reference" error. When I set the column
value
of "Project Name" to three and then reference the correct column for
each
"Project Number" and "Project Manager", it does not populate the table
for
new entries.

The more I search in this discussion group the more I am confussed.
Right
now, I have no code and all three controls are text boxes. This causes
data
entry to be done every time, even if it is a new file for a current
project,
which causes spelling errors. The data in these three controls needs
to
be
consistent throughout all entries for the same project.

Any ideas?

Ember





.

Relevant Pages

  • Re: Unbound control, testing its value
    ... (copied from VBA Help) ... The DefaultValue property is applied only when you ... An unbound control on my form has a value of true or false ... How do I determine that value for VBA code and testing whether it is True ...
    (microsoft.public.access.forms)
  • Re: VBA Controll Names and Form Controll Names are not syncronising. B
    ... Changing the name of the control does not change references to the control ... in VBA code unless you have AutoCorrect on (and having it on introduces far ... When I move from the form designer in Access to the VBA ...
    (microsoft.public.access.formscoding)
  • Runtime Question
    ... Is there a way in VBA to list the methods corresponding to a control? ... wrting so VBA code to interface another application that has VBA built in ...
    (microsoft.public.vb.general.discussion)
  • Find
    ... things runs fine but when no more matching text is found ... office word as the title bar can i have a control on this ... message thru vba code. ...
    (microsoft.public.word.customization.menustoolbars)
  • Re: How to delete multiple ActiveX controls in Internet Options -> Programs listing?
    ... I now have 2 entries for "Microsoft Terminal Services Client ... Control " which lists mstscax.dll for the control. ... I found several registry entries (and more than just 2 of them; ... I'm not even sure how an add-on gets disabled. ...
    (microsoft.public.windowsxp.general)