auto populate text box based on combo box value
in [Form]
|
Prev: Free migration kit for MS Access developers: MS Office 2010 Web Apps
Next: Setting Size of Switchboard
From: Yappy on 27 May 2010 15:53 Thanks, Daryl. I will give it a try. Right now when I try to go into the code builder for this particular issue, I am getting a DLL error. I will have to try working on this on a different computer. "Daryl S" wrote: > Yappy - > > You need to use the AfterUpdate event of the combo box to populate the other > fields. For the combo box, Column(0) is the first column, so adjust as > needed. The code will look something like this, one line for each unbound > text box (use your control names): > > Me.[Region Number] = Me.LURequestor.Column(5) > Me.[Region] = Me.LuRequestor.Column(6) > > > -- > Daryl S > > > "Yappy" wrote: > > > I would like to set up the following to auto populate the fields below based > > on the value I select in the combo box: > > Rep field = combo box (LURequestor) with all info included pertaining to the > > rep > > The combo box row/source type is Table/Query; row source is SELECT > > qryReps.FullName, qryReps.[Last Name], qryReps.[First Name], > > qryReps.RegionNumber, qryReps.Region, qryReps.Division, > > qryReps.[RSM-Director] FROM qryReps ORDER BY qryReps.FullName; & RepID is > > hidden > > > > Region Number = unbound text box (Column 4) > > Region = unbound text box (Column 5) > > Manager = unbound text box (Column 7) > > Division = unbound text box (Column 6) > > > > I have tried setting up the text boxes with =[LURequestor].[Column](4) in > > each unbound text box with the respective column number but the form shows > > "#Name?" in the field. > > > > I am using Access 2003. What could I be doing wrong? Any help would be > > appreciated. > > > > Yappy |