OpenArgs and FindRecord combination

[Stretholox]

The access website says there is a way to use the open arg in combination with the FindRecord method to open a form up to a specified client name. I'm trying to have a macro that asks the user what student they are looking for and then takes them to the form with that name. The reason I can't use a query or something else is because I have macros on the form page that I want them to have access to.



So my question is this.

What's the best way to make a macro that will
1) ask the user for a name input
2) open an already made form
3) take them to a specific record based on the input name

I tried to use something with InputBox and DoCMD.OpenForm but I'm running face first into a wall any time I tried to combine the two.

thanks for any help you can give

[June7]

Simpler method than using OpenArgs is to have user select student from a combobox then:

DoCmd.OpenForm "form name", , , "StudentID=" & Me.cbxStudents

I use only VBA but macro has equivalent.

[Stretholox]

Can you explain what Me.cbxStudents is? I've seen the style of Me.attribute but I'm a novice at programming and access so I've been tripping over it like a fool.

[June7]

cbxStudents is example of name for combobox control.

Me is alias reference for the form the code is behind (also works behind report).

[Stretholox]

Don't combo boxes require me to give them a list of all the names. Can they type the names still? Is there a way to link the combobox to a name list so if I add a name or student it will add it to the combo box?

[June7]

A control used only to input filter criteria must be UNBOUND.

Set the combobox RowSource property. Review: http://www.datapigtechnologies.com/f...combobox3.html

Adding a new student 'on-the-fly' while making selection in combobox is complicated. Requires VBA code that uses the combobox NotInList event.

[Stretholox]

A control used only to input filter criteria must be UNBOUND.

Set the combobox RowSource property. Review: http://www.datapigtechnologies.com/f...combobox3.html

Adding a new student 'on-the-fly' while making selection in combobox is complicated. Requires VBA code that uses the combobox NotInList event.

So I figured out using comboboxes in the form itself but I wanted to make it so there was a drop down menue on a report that combined with a macro button to take the user to the form. Is that possible?

[Stretholox]

I appreciate the help. I figured it out