Text box to search record

[rkmaitra]

Hello everybody,
I am very new to Access 2010. I have a form for a table. The table has a Primary Key (autonumber). The displays on record from the table along with a calculated field.
I have 2 questions:
1. I have an unbound text box. I want to type in a number in that text box and want the form to jump to that particular record. My text box is called "Go To", my form is called "April 11", my table is called "April 11". How do I use the GoToRecord macro to go to the record I type in? I have tried setting the 'Record' section on the macro to Go To and the Offset to both [Go To] and &[Go To] - both of which produce no effect.
2. I also have a button on my form which opens another form bound to the same table ("April 11"). When I click that button, I want to open the new form ("April 11 Subdivisions") at the same record that the original form was at. At present I have a macro which opens the new form 'on click' of the button, but opens the form at record 1.
Many thanks for your patience and help,
Rudra

 

[pbaldy]

If you use the combo box wizard on a form bound to a table, it should offer you a solution to number 1. For number 2:

http://www.baldyweb.com/wherecondition.htm

Note the link at the bottom if you want all records to still be available on the second form.

 

[rkmaitra]

Thanks a million, worked a treat. This is me shaking you by the hand.
Rudra

 

[pbaldy]

This is me shaking back. Welcome to the site by the way!