TAB CONTROL updates

Tech-Archive recommends: Fix windows errors by optimizing your registry



I have a data entry form that is a series of Tabs. You go thru the tabs and
enter your data.

I have one tab [VALIDATION] where you assign an Investigator
[AssignInvestigator]. After an investigator has been assigned, I use a SQL
statement to insert the investigators name into the the Investigation table,
that works fine no problem. The problem is if, after you assign the
investigator's name, you click on the [INVESTIGATION] Tab, the investigators
name [INVESTIGATOR]is blank. Unless you go to a new record then come back to
this one, then it shows up, because, like I said the SQL statement works.

I've tried all kinds of Refresh and Requery statements, to occur on the
AfterUpdate of [AssignInvestigator]. Also on the GotFocus & OnCurrent
eventof the [INVESTIGATION] tab. Nothing is working.

Any suggestions?

Thanx!
RHM

--
Message posted via http://www.accessmonster.com

.



Relevant Pages

  • Re: TAB CONTROL updates
    ... I have one tab where you assign an Investigator ... this one, then it shows up, because, like I said the SQL statement works. ... I've tried all kinds of Refresh and Requery statements, ... AfterUpdate of [AssignInvestigator]. ...
    (microsoft.public.access.formscoding)
  • RE: Im stuck in a form !!!
    ... this be causing the greyed out navigation buttons. ... I can only tab around my fileds in the current form, and am not able to tab ... "John Vinson" wrote: ... I have a simple data entry form with 4 fields. ...
    (microsoft.public.access.forms)
  • RE: Im stuck in a form !!!
    ... "fenrir" wrote: ... this be causing the greyed out navigation buttons. ... I can only tab around my fileds in the current form, and am not able to tab ... I have a simple data entry form with 4 fields. ...
    (microsoft.public.access.forms)
  • Im stuck in a form !!!
    ... I can only tab around my fileds in the current form, and am not able to tab ... navigation buttons highlighted and they dont work when clicked as there is ... "John Vinson" wrote: ... I have a simple data entry form with 4 fields. ...
    (microsoft.public.access.forms)
  • RE: Im stuck in a form !!!
    ... I can only tab around my fileds in the current form, and am not able to tab ... navigation buttons highlighted and they dont work when clicked as there is ... I have a simple data entry form with 4 fields. ... you may also want to set the form's Cycle property to All Records ...
    (microsoft.public.access.forms)