Never mind, I figured it out.
"Niniel" wrote:
[Quoted Text] > I looked around a bit but all questions I found dealt with updating just one
> field. What I want to do is load an entire record ie. auto-populate several
> fields at once.
> I have a table that is linked to a location table via a location id. In a
> form based on the main table, I would like to just enter the name of the
> location, and then have the form pull in and show all related information.
> I was thinking about using a subform to display the location data, but I'm
> having trouble getting it to work.
> Any help would be appreciated. Thank you.
|