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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tabbed form and Got Focus

Status
Not open for further replies.

mraetrudeaujr

Technical User
Dec 20, 2004
137
US
I am building an Access 2000 application using the 'Tabbed Form' style of form.

First, a little history; currently, the users have been entering and searching in the raw table itself. This practice has gone on for years. After taking hours to piece together data for the 'higher ups' in our organization, I have convinced my supervisor that this practice has to stop if we want to control how the information is being captured. So I am in the process of building an 'Access application' by making them use a form for data entry and searching.

On the first "tab" I have a list box that is running a query to give the users a pseudo look at the 'table view'. What I want to do is insert an "event procedure" on the 'On Got Focus' property of this List Box control. This is so that any time they go back to this 'tab' with the list box, it will always reflect the changes that have been made, or records added. How do I go about this?
 
I think this is what you are looking for--

In form Design View, click on the tab with the listbox (it should show up in the property sheet as a 'Page'). In its OnClick event procedure, put
me!WhateverIsTheListboxName.SetFocus
me!WhateverIsTheListboxName.Requery


Bob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top