Refreshing Subform

  • Thread starter Thread starter Josef
  • Start date Start date
J

Josef

hi,

i have records that are deleted in a subform when i click a button in
the main form. what results are fields with #DELETED.

how can i refresh the subform data once they are deleted ??

many thx (again)

joe.
 
Josef said:
hi,

i have records that are deleted in a subform when i click a button in
the main form. what results are fields with #DELETED.

how can i refresh the subform data once they are deleted ??

many thx (again)

joe.
Click to expand...

Suppose the subform control (on the main form) that is displaying the
subform is named "sfMySubform". Then when you need to requery it,
execute this statement:

Me!sfMySubform.Requery
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PLEASE HELP: Refresh a subform 5
refresh/requery subform 2
Refreshing a subform 2
Problem refreshing subform 2
Subform Refresh Fails on Opening Form. Works Otherwise. 3
Deleting records from a subform 2
Refresh calling form 7
Update a combobox on another form 1

Back
Top