[AccessD] VBA syntax for selecting a record

Andy Lacey andy at minstersystems.co.uk
Thu Jan 18 23:54:03 CST 2007


Well I don't reckon it'd be much different. Try

With Forms("Yourformname").Form
  .RecordSetClone.FindFirst "YourPrimaryKeyField=" & Me.txtKey
  If Not .RecordSetClone.Nomatch Then
    .BookMark=.RecordSetClone.BookMark
  End If
End With


-- Andy Lacey
http://www.minstersystems.co.uk 


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
> Sent: 19 January 2007 04:47
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] VBA syntax for selecting a record
> 
> 
> Hi Andy,
> Thanks but I should've have been more specific (got a head 
> cold and not thinking real clear :o(
> 
> What would be the correct VBA syntax for selecting a record 
> on a continuous form using the primary key from a separate 
> module be (not the form's own module).
> 
> Here's what I'm after: I'm on a specific form and I change 
> the record being worked on via code. I want to have the 
> selected record be the same on another open form (which 
> precedes this form in the work flow). That form displays the 
> same set of record using the continuous form style.
> 
> I want to do this so that when the current form is closed the 
> other form appears to be highlighting the same record that I 
> switched to on the form that was just closed.
> 
> I hope that is clearer.
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
> Sent: Thursday, January 18, 2007 4:01 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] VBA syntax for selecting a record
> Importance: High
> 
> John
> It'd be something like:
> 
> With Me.RecordSetClone
> .FindFirst "YourPrimaryKeyField=" & Me.txtKey If Not .Nomatch 
> Then Me.BookMark=.BookMark End If End With
> 
> 
> Assumes a field like txtKet holds the record number sought
> 
> --
> Andy Lacey
> http://www.minstersystems.co.uk
> 
> 
> 
> 
> --------- Original Message --------
> From: "Access Developers discussion and problem solving" 
> <accessd at databaseadvisors.com>
> To: "'Access Developers discussion and problem solving'" 
> <accessd at databaseadvisors.com>
> Subject: [AccessD] VBA syntax for selecting a record
> Date: 18/01/07 09:38
> 
> 
> What would be the correct VBA syntax for selecting a record 
> on a continues form using the primary key?
> 
> TIA
> John B.
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> ________________________________________________
> Message sent using UebiMiau 2.7.2
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 





More information about the AccessD mailing list