Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subform on a tab control

Status
Not open for further replies.

harleyhead

IS-IT--Management
Apr 19, 2006
17
US
I have a subform on a tab control page. I would like to have the information in the subform refreshed as it is displayed. To explain further, step by step:

1. Tab is clicked for the page containing the subform in question.
2. The subform and the query results are displayed in a tabular format. The subform contains a step number and an instruction.
3. An entry is made with a step number that is less than the last record displayed.
4. A different tab is selected and subsequent form displayed on it.
5. Tab is clicked for the subform in question again.

What I want displayed at this point is the contents of the subform to be reordered that the last entry made is now displayed where it belongs sequentially.

How to?
 
harleyhead,
Depending on the form and subform data source, use requery or refresh.

Jdemmer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top