Linked Combo Box Problem

[JerSand]

My task, as I understand it, is to use two combo boxes to enter data for two fields in a table. The first combo box is called "Source Reference" -- it's the titles of the documents from which the user has taken some information. The combo box list is to display distinct titles as the user adds records to the table. I have no trouble to this point -- I simply tie the combo box to a select query, add the word "distinct" at the appropriate place on the row source property, and requery after update.

Here is the problem: The user wishes the next combo box --"Source Date" (the date of the document entered in the Source Reference combo box) -- to automatically display the date if he/she selects a Source Reference that he/she has already entered. The Source Date combo box should be empty -- ready for entry of a date -- only if the Source Reference just entered was a new one.

I'm stumped, and would be grateful for any help.

Thanks.

JerSand

 

[FEDSEC]

If I get you right.....

In the "After Update" event of your combo box add this code
Me.yourfield = Me.Source Reference.Column(#)

( # = the column with the data you want to populate with)

 

[JerSand]

Thanks, FEDSEC. I'll give it a try. I'm grateful.

JerSand