Open Form and Show the First Record in a list

[ddrew]

On a form I have a listbox that allows me to navigate around my records. The listbox is filtered and I get the redords that I waqnt from the table.

My problem is that when I open the form the record that is showing is one from the table but not one that is in my listbox. I want it to show the first record in the listbox

This is the command I have on open:

 DoCmd.GoToRecord , "", acFirst

which is where the fault lies, but I dont know what I should put in its place. The list is List273 and the form is frm_Profile

 

[jdraw]

For More options when Opening a Form see

http://www.datawright.com.au/access_resources/access_docmd.openform_arguments.htm