Update text box based on data in combo box

[Ember]

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

 

[Ken Snell \(MVP\)]

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

 

[Ember]

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\)]

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.

 

[Ember]

Again, thank you!

Ember

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.