Refreshing new data added in subform and related filtered form

[Guest]

Hi,

I have designed a sub form called 'frm_GrantApplicant subform' that displays
records from a table called 'tbl_GrantApplicant'. The subform
(frm_GrantApplicant subform) consists of 11 fields from this table
(tbl_GrantApplicant) and the remaining fields are displayed in another form
called frm_GrantApplicant. The user can open the 'frm_GrantApplicant' form by
clicking a 'Further Grant Applicant Details' button on the subform
(frm_GrantApplicant subform) next to each record entered and the related
field data for that record is displayed in frm_GrantApplicant (using
Filtering).

The problem I am finding is that each time I add a new record in
'frm_GrantApplicant subform' and then click the 'Further Grant Applicant
Details' form button to add the remaining fields in 'frm_GrantApplicant', the
form opens completely blank (no text boxes or related labels to enter the new
data into). However, if I click the cursor into one of the blank fields below
the record I am adding new data for in 'frm_GrantApplicant subform' and then
open 'frm_GrantApplicant', only then the related fields appear in this form.
How do I set the forms up so that I don't need to click into the blank field
below before opening 'frm_GrantApplicant'?

Hope someone can help? If you require further clarification, please do not
hesitate to contact me.

Kind Regards

Ammo

 

[Brian Bastl]

see reply in original post.
Brian