Updating linked fields on a form 1

[SMHSleepy]

Hello, I have an existing Demographics form which includes a unique identifier (RecNum). I've created a second table which is linked to the Demographics table by this RecNum and includes other fields.
I created a form that includes all the fields in the second table as well as some fields from the Demographics table just for display (i.e. I don't want to edit this info).
Now when I go to enter a new record, I start by entering a RecNum. There may or may not be a corresponding RecNum in the demographics table, but if there is, I'd like the fields to show up on the form but it doesn't. If I close the form, then open again, sure enough it shows all the fields. Is there some sort of "refresh screen" command I could add to accomplish this in real-time? Thanks.

 

[dhookom]

I would use a subform for updating the "other fields" table. Use just the Demographics table for the main form.

Duane
Hook'D on Access
MS Access MVP

 

[SMHSleepy]

Works like a charm, thanks!