Requery a background form

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

Requery a background form

Hello,

Using Access ’03…

I have a form (frm1) that opens when a user opens the database (it’s
kind of a background form w/ a picture).

Once that form (frm1) opens, a pop up form (frm2) opens for data
entry.

What I’ve done is place a subform (sfrm1) on frm1 and set its view to
datasheet. That way when a user enters a record they can intuitively
see the record in the database (even though it’s sitting behind the
pop up form).

E.g., when a user enters a record, the sfrm will automatically reflect
the changes as records go in/out of the database. The only issue is
that I cannot seem to requery the subform when the pop up is open
(which always stays open).

Can I requery a form/subform even though it doesn’t have the focus and
see the changes taking place?

If you're wondering why the sfrm is not on the pop up, it's due to
space/visual presentation.

Thanks for any help
alex
 
I cannot seem to requery the subform when the pop up is open
That is the nature of a most popup forms. Try changing the Modal property
to No (Read the help on them.).
 
That is the nature of a most popup forms.  Try changing the Modal property
to No (Read the help on them.).

--
Build a little, test a little.












- Show quoted text -
Click to expand...

Thanks Karl. I'll give that a shot...
alex
 
Back
Top