Ron, try enforcing the relationship with
SELECT MyParentTableName
GO RECORD RECNO()
and also you might need to refresh after that, but usually is not a requirement.
>I am presently brain dead...
>
>I have a simple form having two tables with a parent child relationship. I want to select a record from the parent, and have the list box refresh with the info from the child. Brain is mush and can't get it right.
>
>If I use a SQL statement to fill the rowsource, clicking on the result row won't give me the child record number (or will it?) and, when I do this, I get a SQL select result each time I refresh.
>
>If I use Alias as the row source type, I can't seem to find out how to filter the display to only the appropriate child records.
>
>Please help.
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould