Restrict Datasheet Column Lookup Based On Previous Column Value

[DaveInIowa]

Is there any way to specify a field's Lookup:Row Source that references a previously set field in the same row?
As an example I've tried setting Row Source to:

SELECT TeeId, Name FROM Tees WHERE (CourseId=[DefaultCourseId]);

I would like the [DefaultCourseId] value to be substituted with the data that was just entered for the DefaultCourseId field.

Does anyone know if this is possible?

Keep in mind I'm trying to accomplish this for a List Box on a Datasheet, not a form.

 

[dhookom]

No.
You might be able to do this in the datasheet view of a form. Roger Carlson has some sample mdbs at

http://www.rogersaccesslibrary.com,

one of which shows how to create cascading combo boxes.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]