It's easier if you do this with VBA. The Form Load Event Procedure should look like:
Private Sub Form_Load()
Me.List0 = Me.List0.ItemData(0)
End Sub
.. where "List0" is the name of the list box control.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of MEL
Sent: Wednesday, July 20, 2011 7:44 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Macros
Unbound list box which just shows all the queries nameSELECT MSysObjects.[Name]FROM MSysObjectsWHERE (((MSysObjects.[Flags])=0) AND ((MSysObjects.[Type])=5))ORDER BY MSysObjects.[Name];
--- On Wed, 7/20/11, John Viescas <john@viescas.com> wrote:
From: John Viescas <john@viescas.com>
Subject: RE: [MS_AccessPros] Macros
To: MS_Access_Professionals@yahoogroups.com
Date: Wednesday, July 20, 2011, 1:03 PM
MEL- (name?)
Is the list box bound to a field in the Record Source? (Does it have a Control
Source?) What is the purpose of the list box?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of MEL
Sent: Wednesday, July 20, 2011 6:20 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Macros
How can I create a macros for the form when the form loads move the focus to the
first query name in the list box.
Thanks
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar