Query-based form with blank fields

[Rubel Romero]

I am having a problem with a query-based form populating fields as
expected, and am hopeful it is a simple solution.

The query is based on several tables, so the query-based form is dynaset
with inconsistent updates.

From a table-based form that I use to drill down to a subset of the
records, I select a record and hit a command button (which closes the
table-based form) to go to the query-based form where I can edit a full
set of fields. I have no problem calling up the form and editing fields
the first time I call up the query-based form. But when I go back to the
records list (via a command button that closes the query-based form) and
then select another record to edit - well, that's where I run into a
problem. The query-based form comes up fine, but the fields are blank,
as though the query hasn't run this second time. If I check properties
for the filter for the criteria, it is there, and it is the correct
number that should have brought up the record. But, nothing but blank
fields.

Would anyone be able to tell me what might cause this, or what I might
have done incorrectly? I would appreciate any direction or advice or
admonishment that could be provided. I probably just need a good slap in
the face, 'cause I've already had enough coffee to last through
Christmas. Thanks in advance for any help - Rubel

 

[Guest]

I select a record and hit a command button (which closes the table-based
form) to go to the query-based form where I can edit a full set of fields.

I think the query needs refreshed. Try adding to one of the command buttons
to close the second form.