Re: Record Navigation

Tech-Archive recommends: Speed Up your PC by fixing your registry

Great stuff.... thanks for your help!!

It works!!!

"Linq Adams via AccessMonster.com" <u28780@uwe> wrote in message
news:7f653bbd99f13@xxxxxx
If you want something to be done based on info from the record you just
moved
to you have to use the OnCurrent event.

Private Sub Form_Current()
Call PremShowHide(form_frmJob.CustID)
Call JobLockdown(form_frmJob.Jobstatus)
End Sub

If you only want these actions carried out on EXISTING RECORDS, not NEW
RECORDS, then

Private Sub Form_Current()
If Not Me.NewRec Then
Call PremShowHide(form_frmJob.CustID)
Call JobLockdown(form_frmJob.Jobstatus)
End If
End Sub

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

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



.

Relevant Pages

  • Re: synchronizing form and list box
    ... In the OnCurrent event of the Form, ... Private Sub Form_Current ... The form contains these three fields plus many ... > highlighted record in the list box changes to reflect the new record ...
    (microsoft.public.access.forms)
  • Re: Do not allow modifications
    ... Using the OnCurrent event of the form... ... Private Sub frmYourForName_Current ... If you also use the same code in the AfterUpdate event of ComplaintNo... ... Candia Computer Consulting. ...
    (microsoft.public.access.forms)
  • Re: Event Procedures on Forms
    ... for ages when going into a new record (status bar reflects 'calculating' so ... Add the same code as you show below to the OnCurrent event of the form. ... is bound to a field in your form's recordsource, it will change depending on ... Private Sub ContractNoExpiration_AfterUpdate ...
    (microsoft.public.access.formscoding)
  • Re: Event Procedures on Forms
    ... This event fires off when the user enters the record. ... Just add the following to your OnCurrent event: ... If it is bound to a field in your form's recordsource, it will change depending on its value in the record. ... Private Sub ContractNoExpiration_AfterUpdate ...
    (microsoft.public.access.formscoding)
  • RE: Update cbx2 based on selection in cbx1
    ... The requery doesn't work on my code even after I've put the requery in the ... OnCurrent event:( ... This is the code in my form (the selection in combobox TransactionType will ... Private Sub TransactionType_AfterUpdate ...
    (microsoft.public.access.forms)