How to open form and go to record with certain ID.

[behnam]

Hi guys,

I know how to open a form, but it automatically goes to the first record. Can someone help me with the vba code to not only open a form (called form1) but takes me to the record with the same ID value as the number stored in a variable called numstor.



Thanks for your help.

[ranman256]

The form has a query set in the RECORDSOURCE property. (use the wizard to build an instant form..it will attach the table/query)
Under TOOLS, STARTUP, put your form name to open as the db opens. It will open to the 1st record.

If you want to go to a record, put a box on the form (be sure to view the NAME of the txt box for the code below..ie txtBoxID)
after update event would be:

  'text box afterupdate
me.filter ="[numstor] = " & txtBoxID
me.filteron = true

[NTC]

another quite simple and common approach is that the form being opened has a record source that is a query; and this query has criteria for numstor