Setting Textbox Value to Combo Box

[jlcash]

I have the following situation in Access 2003 I need some help on:

I have a form that I would like to set up so that when a user selects a time (Quarter/Year) from a combo box, the next field, a textbox, automatically selects the corresponding date.

This form is running from a table "Quarters", and within this are four columns: "Quarter" "Start Date" "End Date" and "Year"

combo box = cboCombo3
Column Count = 2
Column Width = 1
Row Source = SELECT Quarters.Quarte r, Quarters.StartD ate FROM Quarters;
Event: After Update Code =
Private Sub cboCombo3_After Update()
Me!txtStartDate = Me!cboCombo3.Co lumn(1)
End Sub
Control Source = Quarter

textbox = txtStartDate
Control Source = Start Date

When I try and select a value in my combo box in the Form View I get a box that pops up saying "Enter Parameter Value" and "Quarters.Start Date"

Not sure what the problem is, but possible solutions would be much appreciated.

[JKing]

Seems to me like you're referencing the wrong field name.
You want to reference Start Date but you're referencing StartDate under the row source for your combo box.

Change this line to:
Row Source = SELECT Quarters.Quarte r, Quarters.[Start Date] FROM Quarters;

Adding the [] allows you to use field names that contain spaces without them being misinterpreted.